Need help with IF statement

Want to have RYGB symbol auto-populate based on following:

If Status = Complete, set to Blue

If Days Late greater than 29, set to Red

If Days Late < 15, set to Green

Otherwise set to Yellow


  • Christian G.
    Christian G. ✭✭✭✭✭✭

    Write that into seperate IF statement then join them together.


    if([Day Late]@row>29,"Red",else...)

    if([Day Late]@row<15,"Green","Yellow")

    All joined together you get:

    =if(status@row="Complete","Blue",if([Day Late]@row>29,"Red",if([Day Late]@row<15,"Green","Yellow")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!