Help with #Invalid Data Type Error

Heather KHeather K
edited 12/09/19 in Formulas and Functions
04/23/19 Edited 12/09/19

I have a RYGB column (Color Status) that has a formula =IF(AND([email protected] = 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



Sign In or Register to comment.