Create Pulse with IF Statement


I am trying to complete multiple IF statement to create a pulse on where a partner is on their project, but am not getting the correct color based on my formula:

Here is my timeframe for each phase:

An example of one of my formulas:

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

Each phase has this formula with it's respective Phase Date, but all should be red based on date:

I'm somewhat new to formulas, so trying to figure out what I am doing wrong.

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!