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.
Lable Status Dots
Comments
-
Hi, Ann, your question is a little confusing. Could you elaborate? Where are you wanting labels vs. colored dots? The following smartsheet blog post highlights over 50 symbols that can be used. You are not limited to RYG symbols.
-
Building off of Mike's response it's also possible, using a formula, to use a "label" (text, like "Good") then turn the RYG column to the green colored ball. Or vice versa.
-
Let me try to rephrase what I'm looking to be able to do.
SO the drop down menus that I know how to use are screen shopped. I know how to change the words on the first one (Not Started/In Progress/Ect).
I'm looking to change the lables on the second one so that I have the Red/Yellow/Green/Blue Dots but also have phrases like "Problem" "In Progress" "Done" and "NA" on the drop down menu with the dots.
-
Hi Ann,
You can't change the text labels of the visual items on a Symbol column—those labels are static and can't be customized.
What you might consider doing is creating a formula with a Dropdown column (which is a different column type from a Symbol column) that will set your custom Dropdown option based on the symbol. An example of this type of formula is as follows:
=IF([Symbol Column]1 = "Red", "Problem", IF([Symbol Column]1 = "Yellow", "In Progress"))
You'll want to edit the above formula to include all of the symbols and corresponding dropdown options, as well as adjusting for your own cell references. More on formulas can be found in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#if
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives