Why won't my yellow indicator show up?

Michelle Barnett

I'm evaluating a field to see if it's greater than 5 days..

=IF([S1-W0]@row > 6, "Red", IF(AND([S1-W0]@row = 5, [S1-W0]@row < 5), "Yellow", "Green"))

This is the formula I'm using. It will show red and green but if it's = 5 days, it still shows green.

Would someone please show me what I'm doing wrong.

Thanks

Michelle

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Michelle Barnett

Hope you are fine, please try the following formula

=IF([S1-W0]@row > 6, "Red", IF([S1-W0]@row <= 5, "Yellow", "Green"))

but please note that your formula will show Green only when [S1-W0] = 6

Michelle Barnett

Hi Bassam,

Thank you for getting back to me. I got an unparseable error, when I entered the formula, but I see that it worked for you in the example above. I just cut and pasted it, I'm not sure why it doesn't work.

Michelle

Bassam Khalil

@Michelle Barnett

Please check your column type, and if you like share me as an admin on a copy of you sheet after you remove any sensitive data.

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.