RYG function based on Status and Start Date

I am able to have the Status (RYG) show up based on Status (which is tied to percent completed). I am trying to add the function so if the Start Date is in the future the status defaults to Green.

This is what I'm using for the RYG now:

=IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green")))

I end up running into issues when I add "OR" and try to make status Green if Start Date is in the future.

Find more posts tagged with

Accepted answers

David Tutwiler

You could start with the Start Date at the beginning. So something like:

=IF([Start Date]@row > TODAY(), "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green"))))

All comments

David Tutwiler

You could start with the Start Date at the beginning. So something like:

=IF([Start Date]@row > TODAY(), "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Red", IF(Status@row = "Complete", "Green"))))

robzas

Thank you - that worked

David Tutwiler

Great! Glad it's working.

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.