Is there a way to use a formula to filter when the count of tasks related to project is 0?
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.