Making tasks with "done" status disappear from linked tables?

[Tess_Wheelwrigh]

Dear All, A new slightly intimidated user here! My team has a to-do list of running action items as one table, linked to a project areas table. I want, when an action item gets marked as “done,” to be able to have that task disappear from linked tables. How do I do this? Thanks!

[Kamille_Parks]

Noobie question: I need help from airtable experts, Currently I'm not able to followup on my leads p... Views

Try using two Link Fields: one for active tasks, one for completed tasks. You can use an automation on your Tasks table, once a task has been marked complete, to move the value of the {Projects (Active)} link field to the {Projects (Archive)} link field. In your Projects table you could hide the {Tasks (Archived)} field from view so you only see the {Tasks (Active)} field, which should now only display clickable titles of the tasks which are active.