Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Link between two values (in 2 different columns)
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!
Comments
-
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
-
Thank you Craig, works perfectly!! Wow, I love Smartsheet!!
Have a nice day,
Regards,
Nadine
-
You are welcome (in both meanings)
Craig
