I’m trying to create a formula that I don’t think should be too complex but I can’t seem to figure it out.

I have an Agenda table with a list of agenda items, and a To Do column that links to a To Do table.

In the To Do table, team members can check off it that thing has been done or not.

I would like to write a formula in the Agenda tab that will essentially remove the To Do items once they have been checked off.

I’m fine with creating a new To Do column and hiding the original one if that’s necessary, but I can’t seem to figure this out.

Any help would be appreciated!