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
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!
Thanks!
Comments
-
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")
-
ABSOLUTELY! THANK YOU SOOOOO VERY MUCH!
-
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.
