Referencing Another Sheet: Count

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good day all:


I am counting number Rows in another sheet. However, I do not want to include the Parent or Grand Parent Row in that count, just the children and grandchildren. thoughts on how I would structure this formula? Thanks

My formula =COUNTIFS({Mi-Config 7.2 WBS Range 1}, 1)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!