Countifs only if its a parent row

AndrewT

Hi guys, running into a dilemma where im trying create a countifs for a dashboard for statuses, but I only want the main status from the parent columns and not the tasks. Screenshot shows the status field has multiple in the status "Draft".

I'm not super familiar with the children/parent fomula and could use a little help!

Skip WBS that is checkmarked will serve as the indicator that the line is the parent.

Thank you all

Paul Newcome

You would use a COUNTIFS to include multiple range/criteria sets.

=COUNTIFS({Status Column}, @cell = "Status", {Checkbox Column}, @cell = 1)

Paul Newcome

You would use a COUNTIFS to include multiple range/criteria sets.

=COUNTIFS({Status Column}, @cell = "Status", {Checkbox Column}, @cell = 1)

AndrewT

Thanks paul this worked great for me!

Paul Newcome

Happy to help. 👍️