I would like conditional formatting by color on "number" displays on dashboards.
Sign in to see the current vote count, add your own vote, or leave a comment.
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. 👍️
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
