Link Fields on Two Tables with Specific Conditions


I’m new to Airtable and just starting to figure it out. I feel like there must be a way to do what I want to do, but I can’t figure it out.

I have one table with a list of items.
I have a second table with a list of tasks that need to get done.
Each task is linked to a specific item- so on my Tasks table there is a column for Item that shows me which Item the task is linked to.
Each Item is linked to multiple tasks.
Each task has a column with a checkbox for ‘Complete’

I need a way to set it so that if all tasks linked to a specific item are marked as complete, the item itself gets marked as complete somehow, so I can filter it out of the main view of items. The item can get marked as complete with either a checkbox field or single select dropdown field or whatever kind of field will work.

Can anyone help me figure this out?

Thank you!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.