Exclude summary row from count

RGeet
RGeet ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

How do I exclude the summary row in the following formula?

=" Yellow: " + COUNTIF(Risk:Risk, "Yellow") + " Red: " + COUNTIF(Risk:Risk, "Red")

Basically, the summary row RYG ball risk indicator should NOT be included in the risk count of the child rows because it causes a count that is one higher than the actual count.

Thanks in advance for any ideas.

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!