Sheet Summary issue - How to exclude Parent rows from the Counts

Jon Stikka
Jon Stikka ✭✭✭
edited 12/09/19 in Formulas and Functions

I would like to set up Sheet Summary to show a counts of Open Tasks, and Completed Tasks - based on the column "Done" being checked or not. 

The "Parent rows" are for reference only, they are not Tasks and shouldn't be counted in the Summary Sheet. How can we exclude them from the Summary Sheet counts?


Screen Shot 2019-12-02 at 12.31.56 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!