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 (traffic lights)
Hi - Can we have set with 5 traffic lights. There is currently four and we use them to represent on-track (green), at risk (orange), overdue (red) and complete (blue). We feel we are missing one to indicate 'not started'.
You already have a grey traffic light but it is in another set of four and it would be very helpful if this could be added to the traffic light set to make 5.
It is the little details.
Thanks
Grace
Comments
-
Hi Grace - good suggestion, I will submit this to the product team!
One option is to use conditional formatting to color the RYGB box if your task has not started. This means you could have a rule that colors the box grey if the RYGB box is blank (not started). Then when you select an option, the background color will be removed and your RYGB ball will appear.
We also have other symbol columns that have 5+ options you might consider using.
-
I too use the traffic lights in the management of a portfolio. Projects on schedule are green, yellow if within 2 weeks of due, red if past due, and blue when complete. I also use the value of grey when a project has not yet started and black when it has gone on hold. Unfortunately, as Grace indicates there are only 4 traffic symbols. I use 6. If you increase the amount to 6 symbols it will give a PM, Program and Portfolio Managers much more flexibility. I have programmed in the code to make them work perfectly however I only get the words grey and black instead of the symbols for the additional colors. I understand this has already been submitted to the product team and also there is a set of symbols with 6 items however smiley faces will not fit into my environment or depict accurately what I need to get across. A second part of this request is in the creation of a report and exporting to Excel. Only the words transfer to Excel and not the symbols. The only option then is conditional formatting or copying in images.
Best regards,
Rick
-
Hi Rick. I'm interested to see how you were able to program the automated status updates of your symbols. Would you be willing to share the code?
Thanks,
Gwen
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives