#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Counting A Range of RYG Balls at Once

Options
edited 12/09/19

I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540.  I have tried various formulas but I keep receiving and error.  Can someone help me by letting me know what I am doing wrong?    Here are few formulas I have tried.

=COUNTIF(CHILDREN([Status of Completion]1:Status of Completion]540), "Red")

=COUNTIF(CHILDREN(Status of Completion), "Red")

I've tried this one, I found on the community group site as well.

=IF((COUNT(CHILDREN(Complete1)) = (COUNTIF(CHILDREN(Complete1), 1))), "Green", IF(COUNTIF(CHILDREN(Complete1), 1) = 0, "Red", "Yellow"))

=IF(AND([Column2]1 = 1, [Column3]1 = 0), "Green", IF(AND([Column2]1 = 0, [Column3]1 = 1), "Red"))

Nothing seems to be working. It keeps saying #UNPARSEABLE

Thanks!

Tags:

• Options

Give this formula a try and let me know if that works for you:

="Green: " + COUNTIF([Status of Completion]:[Status of Completion], "Green") + " Yellow: " + COUNTIF([Status of Completion]:[Status of Completion], "Yellow") + " Red: " + COUNTIF([Status of Completion]:[Status of Completion], "Red")

• Options

ABSOLUTELY!  THANK YOU SOOOOO VERY MUCH!

• Options

You're welcome! I used [Status of Completion]:[Status of Completion] to count everything in the column rather than using CHILDREN(). Makes it a little easier to manage.

This discussion has been closed.