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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives