Help with #Invalid Data Type Error

Heather K

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

Andrée Starå

Hi Heather,

What type is the Aging column?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Heather K

It is a Text/Number column because I want the formula to give me the total number of Red's

Andrée Starå

Ok.

Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

Andrée Starå

This is what the error message means.

#INVALID DATA TYPE

Cause

The formula contains or references an incompatible data type, such as =INT("Hello")

Resolution

Make sure the formula references the correct data type.

Brian W

Is there an #INVALID DATA TYPE somewhere in the [Color Status] column? That will throw off the COUNTIF formula. 

Heather K

Yes, I'm sharing it now.

Andrée Starå

Glad we got it working!

Best,

Andrée