Seeking Help with nested IF Function

Options

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

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!