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.
Creating a formula to show a mixture of RYB balls and text
Comments
-
There is no way to do this with the official "Smartsheet Symbols".
Assumptions:
1. You have 2 columns in your sheet. Status (Dropdown): Not Started, In Progress, Complete RYG (Symbol): Red Ball, Yellow Ball, Green Ball
2. Everyone is an Admin OR you don't lock either of the columns
3. To indicate Status, some team members want to use the RYG balls & others want to use the words in the Dropdown list.
Option 1: You could use Text Symbols in a Dropdown Column with Conditional formatting. Unicode Text Example Sheet
Dropdown List:
⬤ - Not Started
⬤ - In Progress
⬤ - Complete
More info on Unicode Text Symbols are in this post:
Unicode Text Symbols are extremely useful
Here is the method we use on my team: Other Method Example
1. The decision was made to only change the Dropdown List values
2. Status is automated using conditional formatting & a formula in the colored ball column.
Good Luck!
-Kris
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives