Text to Traffic Light symbols

Options
BecBlah
BecBlah ✭✭
edited 06/07/23 in Formulas and Functions

I am trying to turn text in a status column i have shuttled over using data shuttle from Excel into Smartsheet into a traffic light symbol. My column is Called Status, and the text in the column is green, yellow, red. I thought if i changed the column type smartsheet would identify this and convert to a traffic light symbol, but alas not!

I am using this formula, which works if i just have one result, but not when adding in the other variables. I get unpassable. PLEASE HELP

=IF(Status@row = "Green", "Green". IF(Status@row = "yellow", "Yellow", IF(status@row = "red", "Red")))

Tags:

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @BecBlah

    I hope you're well and safe!

    Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • BecBlah
    BecBlah ✭✭
    Options

    I figured it out, You need to have the data coming through capitalized for smartsheet to recognise the trafffic light colour. they were all lower case in the original import, so had to update my source data.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @BecBlah

    Excellent!

    Happy that you figured it out!

    That was the first thing I looked for, which looked correct at first glance.

    Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Options

    Hi BecBlah,

    There is one comma added in your formula =IF(Status@row = "Green", "Green". , so it is showing the error, you can try the below formula.

    =IF(Status@row = "Green", "Green", IF(Status@row = "yellow", "Yellow", IF(Status@row = "red", "Red"))) 

     I hope this works for you!

    Have a Good Day! 

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!