Formula creation to auto-populate priority symbol

Hello,

I'm looking for help with creating a formula. I'm trying to auto-populate the "Project Heath" column (red, yellow, green symbols) based off of my "Provider Start Date" column.

If "Provider Start Date" is in 15 days or less from today, the "Project Heath" should be “red”

If "Provider Start Date" is 16 days to 34 days from today, the "Project Heath" should be “Yellow”

If "Provider Start Date" is 35 days or more from today, the "Project Heath" should be “green”

Can someone please assist with creating this formula?

Thanks in advance,

Kaitlyn

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try something like this...

=IF([Provider Start Date]@row >= TODAY(35), "Green", IF([Provider Start Date]@row >= TODAY(16), "Yellow", "Red"))

All comments

Paul Newcome

Try something like this...

=IF([Provider Start Date]@row >= TODAY(35), "Green", IF([Provider Start Date]@row >= TODAY(16), "Yellow", "Red"))

Kaitlyn Carroll

Awesome! Thank you, Paul!

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