I need help with If formula

DanB2023

Hi there Im pretty new to smartsheet and trying to get a stsus column to return a symbol value based upon date and progress column

I'm tyring to get the following

IF date is in thepast and progress is nt 100% = RED

IF Progress is 100% = GREEN

IF date is future and progress is not 0% = YELLOW

IF date is today and progress is 0% = RED

IF date is future and progress is 0% = Grey

When I've applied simple IF formulas based upon just date it returns the word (RED, YELLOW etc..) rather than the coloured symbol

Can anyone help?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Make sure your column is set to the proper symbol column type. Your formula outputs are also case sensitive, so try not using all caps.

"Red"

"Yellow"

"Green"

"Gray"

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.