Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Project Linked Field - Hide Done Tasks

Topic Labels: Sync
228 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a Tasks table, which has a Status field (Started, Done, etc) and a multipel link to projects table. In project table I have the lookup field, which shows me links to all tasks in that project. I can enter tasks here and also click to see task status, etc. This is perfect.

But in the tasks table, when a task is marked as Done, I just want to hide it from both tables. I have tried multiple formulas and rollupfields, which does what I want but they are just a text list of tasks. I have also created a view hiding “Done” and then filtered that view in the lookup, but nothing happens.

Example: This record has all tasks marked Done, which the rollup field sees. But the linked field does not:
image

0 Replies 0