Count all of the Level 1 Parent rows in a SmartSheet

In the document's Summary Sheet, I want to count all of the Level 1 parent tasks in the Sheet itself. In the example above, the answer is 2.

Best Answer


  • That is AWESOME!

    Much more elegant than a formatting a rule I was going to apply to the Task Name if I didn't get a better answer.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!