Basic question on COUNT formula

CJB

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.

Jason Duryea

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())

Jason Duryea

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())

CJB

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.