Is there a way to count the number of CHILDREN in a column?


I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and then "Project Name" (CHILD). I want to count the total number of CHILDREN in that column, but exclude the PARENT rows in order to COUNT the number of CHILDREN, and hence, the total number of projects. Can this be done?




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!