Formula linking to another table checkbox

[Dena_Handler]

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!

[Justin_Barrett]

A very similar question was asked not long ago. Here’s the thread, where you can find my response. Will this work for your scenario?

List of non-completed tasks for a project Ask the community

I have a table of projects, and a table of tasks, and I can create new tasks within a project by entering them directly in the column linked to the tasks table. First of all I’m curious if this is the best way to do things, since technically I’m creating a many-to-many join where I can have tasks that are unassociated, or tasks that are associated with several projects, both of which I have no intention of ever doing; I only want each project to have 0 or more tasks that are strictly associated…