Filter based on counts in group

1

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

2
21438Ă—887 109 KB

2

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
3

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