Formula for status color symbols

System Employee

02/13/25 edited 02/13/25 in Smartsheet Basics

This discussion was created from comments split from: Automation with symbols.

0 · Share on FacebookShare on Twitter

Answers

• 

  Desirée Odegard ✭✭

  02/13/25

  Did anyone have an example of the formula to use?

  I'd like certain cell values to change the priority column that has "red, green, gray, & yellow circle symbols".

  

  

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  02/13/25

  Desirée Odegard

  Feb 13, 2025

  Did anyone have an example of the formula to use?

  I'd like certain cell values to change the priority column that has "red, green, gray, & yellow circle symbols".

  https://us.v-cdn.net/6031209/uploads/R6CTMA7QZQZ5/image.png

  https://us.v-cdn.net/6031209/uploads/0SZH5079ELPJ/image.png

  You would need to use what is called a "nested IF" formula. The details would depend on exactly what you need / how you expect it to work.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10xViz

  Would you benefit from getting my help in person?

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet