Link between two values (in 2 different columns)

Nadine Bolduc

I've created some values for my "status" column (In Progress, Delayed, etc.) and I've created some symbols to match these values (green, red, etc.) in another column. I use both. 

 

I'd like to link those values, ex. : if I choose "In Progress" in column A, then the green symbol will automatically appear in the column B. How can I do that? I guess a I have to use the fonctions...

 

Thanks!

J. Craig Williams

You'll need to use "nested if's", like this:

 

=IF([status]23 = "In Progress", "Green", IF([status]23 = "Delayed", "Yellow", "other IF's continue here"))

 

The symbols have text values.

 

See the help article:

https://help.smartsheet.com/articles/775363-using-formulas

and the associated template (referenced in the first couple of paragraphs of the article) for more.

 

Hope this helps.

 

Craig

 

Nadine Bolduc

Thank you Craig, works perfectly!!  Wow, I love Smartsheet!!

Have a nice day,

Regards,

Nadine

J. Craig Williams

You are welcome (in both meanings)

 

Craig