COUNTIF with Parent rows only, exclude children

cody
cody ✭✭
edited 12/09/19 in Formulas and Functions

I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include the status column GYRB. For the metric sheet, I need all children rows to be excluded. 

 

The metric sheet is so I can track all parent projects without the children rows inflating the data.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!