Automating RYG if a date is too far past another

I have two columns "Date 1" and "Date 2", I want to have a formula for the status column using the RYG Status balls that will:

- Green if Date 2 is less or equal to 10 days past Date 1

- Red if Date 2 is more than 10 days past Date 1

Please help

Find more posts tagged with

Automations

Accepted answers

Jeff Reisman

@Dustin Koenig This ought to do it...

=IF([Date 2]@row > ([Date 1]@row + 10), "Red", "Green")

In English: If Date 2 is greater than 10 days past Date 1, set the ball to red, otherwise set it to green.

All comments

Jeff Reisman

@Dustin Koenig This ought to do it...

=IF([Date 2]@row > ([Date 1]@row + 10), "Red", "Green")

In English: If Date 2 is greater than 10 days past Date 1, set the ball to red, otherwise set it to green.

Dustin Koenig

That worked, thank you for your 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.