Help with #Invalid Data Type Error

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

Find more posts tagged with

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…