Create Pulse with IF Statement

hnc0607

Here you go:

Paul Newcome

And the row you are displaying is showing as "Red"?

Here's the breakdown of how your formula currently reads:

If the date is blank, output blank.

If the date is less than or equal to 3 days in the future, output red.

If the date is less than or equal to 4 days in the future, output yellow.

If the date is less than or equal to 5 days in the future, output green.

Is the date column set as a date type column, and how exactly is it being populated?

hnc0607

figured it out!

=IF(ISBLANK([Phase 1 Date]@row), " ", IF([Phase 1 Date]@row <= TODAY(-5), "Red", IF([Phase 1 Date]@row <= TODAY(-3), "Yellow", IF([Phase 1 Date]@row <= TODAY(2), "Green"))))

Paul Newcome

Ah. So you were looking for when dates have gone past a certain point in the past and not within a certain period in the future. That's where the confusion was.