Automating RYG if a date is too far past another

Dustin Koenig

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

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.

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!