Automation

Hello, I am looking for a way to condition a symbol column to updated from a text column. Any tips?

Best Answer

  • Stefan
    Stefan ✭✭✭✭✭✭
    Answer ✓

    Hi @AGM ,

    ahh, the screenshot makes it easier to help :-)

    What you need is a nested IF formula that caters for your status.

    As you have only 4 colour balls but 5 options you may need to switch to other symbols providing more than 4 icons.

    For easier reading let's say: refining = 1 / defined = 2 / in-progress = 3 / completed = 4 / accepted = 5.

    =IF([Schedule State]@row = "1", "Red", IF([Schedule State]@row = "2", "Yellow", IF([Schedule State]@row = "3", "Green", IF([Schedule State]@row = "4", "Blue", "Grey"))))

    Hope this helps

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!