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
Does anyone know if it is possible to combine text and RYB symbols in one cell. For instance, I am creating a written key to another spreadsheet and want to show "[Red ball symbol] = "Not Started", [Yellow ball symbol] = "In Progress" etc.
Thanks.
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
