If formula for RGYB balls

Options

Hi All,

I want to create a column so when i change the colour of the ball it changes to a set word.

So Green will say "install" for column 7

Red will say "work needed" for column 7

Yellow will say "At VC" for column 7

Blue will say "Back from VC" in column


Tags:

Best Answer

Answers

  • Hi Andrée, Thanks worked a treat. Thanks so much.

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

    Excellent!

    You're more than welcome!

    Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!