Count # of Parent Rows in a Sheet

Options
CLaughrey
CLaughrey
edited 12/09/19 in Formulas and Functions

What formula can I use that simply counts the number of parent rows in a single sheet?

 

My scenario: Each parent row is a different customer.  I want to know how many active customers a particular PM is working with and link that number to a metric widget on the PM's internal dashboard. 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!