Need assistance writing a formula w/ Red, Yellow, Green

Column reference is [Open Days]@row

If the number of open days is =< 7, I would like it to show the Green symbol, if between 8 and 29, yellow, and >= 30, red.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

All comments

=IF([Open Days]@row<=7,”Green”,IF([Open Days]@row<=29),”Yellow”,”Red”))

Thanks for responding. Unfortunately it didn't work for me. Getting error: #unparseable

I see the issue. I originally used an AND function and removed it. I forgot to remove a ).

=IF([Open Days]@row<=7,”Green”,IF([Open Days]@row<=29,”Yellow”,”Red”))

Still not working for me. Dang!

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.