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.
Help Article Resources
Check out the Formula Handbook template!