What is wrong with this formula?

Hi,

Could one of you please tell me what is wrong with this formula:

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

I keep getting an #UNPARSEABLE error.

Find more posts tagged with

Accepted answers

Paul Newcome

You need open and close parenthesis after the first TODAY function.

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

If your [% Complete] column is actually set up to be a percentage, then you will also want to change your criteria there. Percentages in Smartsheet are calculates as a percentage of 1.

So 100% = 1, 50% = .5, etc., etc.

=IF([% Complete]@row = 1, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))

All comments

Paul Newcome

You need open and close parenthesis after the first TODAY function.

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

If your [% Complete] column is actually set up to be a percentage, then you will also want to change your criteria there. Percentages in Smartsheet are calculates as a percentage of 1.

So 100% = 1, 50% = .5, etc., etc.

=IF([% Complete]@row = 1, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))

Anirudh Sure

Thank you Paul. You addressed both of my errors. Super helpful. Worked as soon as I fixed these two issues.

Paul Newcome

Happy to help! 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.