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…
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
