Seeking Help with nested IF Function

Renee McInerney

This is the logic

 

Yellow would occur if [due date] is within next 3 days

Red would occur if [due date] is today or in the past

Blue would occur if [% complete] = 0 AND the [due date] is more than 3 days away

Green would occur if [% complete] is greater than 1% AND the [due date] is more than 3 days away

Kelly Moore

Hey @Renee McInerney

Try this

=IF([due date]@row <> "", IF([due date]@row <= TODAY(), "Red", IF(AND([due date]@row >= TODAY(), [due date]@row <= TODAY(3)), "Yellow", IF(AND([% complete]@row < 0.01, [due date]@row >= TODAY(3)), "Blue", IF(AND([% complete]@row > 0.01, [due date]@row >= TODAY(3)), "Green")))))

Let me know if we need to tweak this

cheers

Kelly