Status Symbols

Dee Randall

Can you formulate status symbols to change based on % numbers in another cell?

J. Craig Williams

Dee,

 

Yes you can.

 

This formula will show a RED status ball when the % Complete in row 23 is less than 50%

 

=IF([% Complete]23 < 0.5, "Red")

 

A couple of notes:

If you want to see the balls instead of the text "Red", set the column type Symbols and choose the type of symbol you want.

If the cell is formatted as percentage (using the % icon), the value is 0-1 for 0-100%.

If the cell is just text/numer, then 0-100 is 0-100%. Adjust the formula accordingly.

 

Automation of RYG balls are discussed here:

https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

 

Formulas are here and there's some examples in the Template linked there to status type formulas:

http://help.smartsheet.com/customer/portal/articles/775363

 

Hope this helps.

If you need more specific suggestions, let me know.

 

Craig