Basic question on COUNT formula
Hi - new to SmartSheet, so forgive the basic question. If I just wanted to count the values in the rows that are blue and NOT the child rows, how would I go about doing that? Thanks in advance.
Best Answer
-
You could create a helper column called "Level" with a column formula as shown below. Then count the rows where Level equals 0.
=COUNT(ANCESTORS())
Answers
-
You could create a helper column called "Level" with a column formula as shown below. Then count the rows where Level equals 0.
=COUNT(ANCESTORS())
-
Thank you! That worked. Wonder if you could help me on another problem. In the column called "TA", I'd like to count the number of times that "SC/SE" is used and the number of times "Cross TA" is used. Any recommendations in terms of formulas? Thanks in advance.
Help Article Resources
Categories
Check out the Formula Handbook template!