This is great. Is there a way to do this based on a status vs. a number count? For example, Status = Complete = Green, Status Scheduled = Orange. Any help would be awesome. I am happy to share links to my page or provide Screenshots. Thank you!
@SchoolofSheets2 жыл бұрын
Yes you could base it off of any parameter you want. Ultimately charts are numerical so the data would need to be counted based on status. You can visualize other ways outside of charts though. Reviewing your specific assets in Smartsheet would require a consultant engagement. :)
@kiloj757maw2 жыл бұрын
I'm trying to do something similar. If the number = 1, make it green. If the number = 2, light green. If number = 3, yellow. If number = 4, light red. If number = 5, dark red. Is this possible?!
@SchoolofSheets2 жыл бұрын
Yes, you will need 5 columns. One for each color like in this video so you can expand on the principles shown here. Each column equals one series in the chart which you can apply a unique color to.
@neilwatson1683 жыл бұрын
How did you get the small chart symbol in the name of the dashboard?
@SchoolofSheets3 жыл бұрын
It's an emoji which you can actually use anywhere you would use normal text, they even work in formulas! 🥸