Invalid data type when using formula

I am trying to create health status column in my sheet and I want it to generate for me a colored ball in the column and I am using this formula: =IF([% Complete]@row, "Blue", IF([Due Date]@row, <TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))

I am getting the INVALID DATA TYPE message in some rows, INCORRECT ARGUMENT SET in some rows and in some rows it's working fine. Please advise.

Find more posts tagged with

Accepted answers

All comments

SteyJ

Hello @Latreva Washington,

What is the logic you would like to have for the health bar? I am trying to determine what blues purpose is but there is no logical expression there to set blue to true, this may be one of your issues.

If you'd like blue to be logic for no data in %complete column, you can try this formula

=IF([% Complete]@row = "", "Blue", IF([% Complete]@row = "100", "Green", IF([Due Date]@row <= TODAY(5), "Yellow", IF([Due Date]@row > TODAY(0), "Red"))))

I look forward to hearing back from you to help resolve this issue!

Latreva Washington

Logic - please let me know if this doesn't make sense. I am still learning how to understand what formulas are 'saying'

Complete = Blue

In progress - on schedule = Green

In Progress - <= TODAY(5) = Yellow

Past Due - Due date greater than today = RED

SteyJ

https://community.smartsheet.com/discussion/comment/390217#Comment_390217

Thank you @Latreva Washington,

You can try this formula

=IF([% Complete]@row = "", "Green", IF([% Complete]@row = "100", "Blue", IF([Due Date]@row <= TODAY(5), "Yellow", IF([Due Date]@row > TODAY(0), "Red"))))

Hope this helps!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.