Help with #Invalid Data Type Error

Heather K
Heather K ✭✭
edited 12/09/19 in Formulas and Functions

I have a RYGB column (Color Status) that has a formula =IF(AND(Done@row = 1, [Parent Check]@row = 1), "Blue", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 240, "Red", IF(AND([Days Open]@row > 119, [Days Open]@row < 240), "Yellow", "Green")))) which is working to give me the red, yellow, green or blue ball. 

In another column, I am trying to count all of the Reds from the Color Status column with the formula =COUNTIF([Color Status]:[Color Status], "Red"). However, this is giving me an #Invalid Data Type error.

Can anybody help me figure out why I'm getting this error? Thanks

Screenshot 1.jpg

Screenshot 2.jpg



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!