Automate RYGB Balls

Shannon Heward

I'm trying to automate RYGB balls by Date Needed [date] and Completed [checkbox] fields.

Blue - Completed field is checked.

Green - Up to 3 Days after Date Needed

Yellow - 4-5 Days after Dated Needed

Red - 6 Days after Date Needed

Could you please assist? Thank you.

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this...

=IF(Completed@row = 1, "Blue", IF(TODAY() <= [Date Needed]@row + 3, "Green", IF(TODAY() <= [Date Needed]@row + 5, "Yellow", "Red")))

Shannon Heward

Thank you, Paul. This is PERFECT! I greatly appreciate your help!

All comments

Paul Newcome

Try something like this...

=IF(Completed@row = 1, "Blue", IF(TODAY() <= [Date Needed]@row + 3, "Green", IF(TODAY() <= [Date Needed]@row + 5, "Yellow", "Red")))

Shannon Heward

Thank you, Paul. This is PERFECT! I greatly appreciate your help!

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