How to Make Dynamic Color Changing Charts in a Smartsheet Dashboard | Smartsheet Tutorial

[@stevereed8330]

Very nice Dan!

[@SchoolofSheets]

Thanks, Steve!

[@GeorgeAllenPCsAllen]

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!

[@SchoolofSheets]

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. :)

[@kiloj757maw]

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?!

[@SchoolofSheets]

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.

[@neilwatson168]

How did you get the small chart symbol in the name of the dashboard?

[@SchoolofSheets]

It's an emoji which you can actually use anywhere you would use normal text, they even work in formulas! 🥸

[@neilwatson168]

@@SchoolofSheets thanks!