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

edited 12/09/19 in Archived 2017 Posts

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 

Please Help!



This discussion has been closed.