Countifs only if its a parent row


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!