Formula using the RYG status balls

deb_63_hydracor

I'm trying to write a formula using the RYG status balls.

These are the criteria:

Green= If the "Deployment Complete" box is checked

Yellow= if there is a date populated in "Module Go-Live Date"

Blue= for anything else (deployment is not complete and Go-Live is not scheduled)

I only got this far with the formula and (of course!) it doesn't work.

=IF([Deployment Complete],1, "Green", IF([Module Go-Live Date]@row, "", "Blue")

Thanks for your help!

Find more posts tagged with

Formulas

Accepted answers

Rich Coles

How about this:

=IF([Deployment complete]@row = 1, "Green", IF([Module Go-Live Date]@row <> "", "Yellow", "Blue"))

This assumes you won't have a case where both Deployment complete and Module Go-Live date are both completed (eg you have an automation that clears the value in Module Go-Live date when Deployment complete is ticked)... if there's a risk of both being ticked, you might want to add a further check in!

Rich

All comments

Frank S.

Greetings @deb_63_hydracor

Please give this a try:

=IF([Deployment Complete]@row = 1, "Green", IF(ISDATE([Module Go-Live Date]@row), "Yellow", "Blue"))

Please let me know if you have any issues.

Rich Coles

How about this:

=IF([Deployment complete]@row = 1, "Green", IF([Module Go-Live Date]@row <> "", "Yellow", "Blue"))

Rich

deb_63_hydracor

Thanks!

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.