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.
Status Symbols
Can you formulate status symbols to change based on % numbers in another cell?
Comments
-
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
