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


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