Countif for top level ident only


I am trying to collate the number of project assigned to individuals by using the COUNTIF function:

=COUNTIF({Project Dashboard Range 1}, "Colin Alexander")

The problem is, that it is picking up all the names in the rows below, which are indented for the project (actions within the Project), is there a way to only count examples which are not indented (top level only)?

Thanks in advance



  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭

    Hello @Richard A,

    I would recommend adding a helper column to identify the level of each row (1, 2, 3, etc.), and then you can change your formula to a COUNTIFS with the additional criteria of only level 1 rows.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!