Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
I would like conditional formatting by color on "number" displays on dashboards.
Are you able to provide a mocked up screenshot for an example? I feel like I undertand what you mean, but I am not sure. If I do, there may be a way to do this already using a stacked bar chart and a little creativity.
Yes! As seen below, we currently manually make the bottom number red or green based on the top number, but we would like the option to set up the bottom number with conditional formatting to automatically change colors based on the top number.
If you set the conditional formatting in your sheet, there is an option when configuring the widget to apply the cell formatting.
It is the paint roller there in the top right corner of my screenshot:
Great! Thank you so much!
Happy to help. 👍️
Sign in to comment or add your vote.
