What formula to show if Green, In Progress

Options
Justin G
Justin G
edited 03/26/24 in Formulas and Functions

Hello,

Looking to create a formula to return the below data. If Blue=Completed, yellow=not started, red=at risk, green=in progress. Thanks!


Best Answer

  • heyjay
    heyjay ✭✭✭✭✭
    edited 03/26/24 Answer ✓
    Options

    There is something wrong with the last set of arguements,

    =
    IF(Status@130="Complete", "Blue", 
    IF(Status@128="Not Started", "Yellow", 
    IF(Status@127="At Risk", "Red", 
    IF(Status@129="In Progress", "Green", ""))))
    

    Did you mean something like the one above? You need to replace the "Status@Row" with your column name. Keep the @row and just replace the "Status".

    ...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!