Filter based on counts in group

Is there a way to use a formula to filter when the count of tasks related to project is 0?

Hello @Sam_Grewal!
You you can add this formula to the projects table in a new column as shown below

Tasks.Filter(Project.contains(thisRow)).count=0

This would get the count of all the task the project contains, regardless of stage and compare it to zero
If you want to count only tasks in a certain stage you could use the next formula

Tasks.Filter(Project.contains(thisRow) and [Task stage].contains(“Not Started”)).count=0

1 Like