Automation

AGM

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

Stefan

Hi @AGM ,

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

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

https://help.smartsheet.com/function/if

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

Andrée Starå

Hi @AGM

I hope you're well and safe!

Try something like this.

=IF(Question@row = "Yes", "Green")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

AGM

Thanks @Andrée Starå!

What if the reference sheet is the same?

Andrée Starå

@AGM

Happy to help!

Not sure I follow! Can you elaborate?

AGM

I am trying to add a formula that will update my "Current Status" with the associated Color Ball based on the "Schedule Status" column.

The formula that you provided is working. However, it does NOT account for multiple options. As I have four different color balls and five "Schedule State" options to coordinate.

Current Formula that is working for single option: =IF([Schedule State]@row = "Accepted", "Blue")

Stefan

Hi @AGM ,

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

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

https://help.smartsheet.com/function/if

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

AGM

Thanks you so much for your assistance. 👍️