Change Metric Widget references based on Checkbox
Hello, I have a question regarding Metric Widget's that would appear on a Dashboard. I do not think this is possible, but I'm asking regardless.
I have a single cell selected that contains a simple sentence. Is it possible for the Metric Widget to update itself to another cell based on the clicking of a checkbox?
So, in this example, the first text cell would be displayed until the equivalent checkbox in the same row is selected. Then the cell underneath would be selected to display the new text, and so on and so forth.
If this is not possible, any ideas on how visualizing this on a Dashboard could be automated? Essentially, the ability to change text based on 'parameters,' without having to do it manually. Thank you!
Best Answers
-
UPDATE: I was able to figure this out, with the help of another thread. Thank you Paul! I used Automations to move rows and then used a Sheet Summary to keep it referencing a single row.
However, I have a similar issue, except now with a Chart Widget and two columns of percentages (compiled via a formula).
When I went to update the Chart Widget, I noticed Sheet Summary wasn't there as an option. Is it possible using another method to automatically update a Chart Widget on a Dashboard? Preferably with the Move Row Automation, as we're already working with that in this Sheet.
-
UPDATE 2: Solved my second issue as well! Don't you love it when you make a thread for no reason.
I used Sheet Summary's again, then put those results into a separate columns within that sheet, then used those columns for reference with the Chart Widget. Works beautifully!
Answers
-
UPDATE: I was able to figure this out, with the help of another thread. Thank you Paul! I used Automations to move rows and then used a Sheet Summary to keep it referencing a single row.
However, I have a similar issue, except now with a Chart Widget and two columns of percentages (compiled via a formula).
When I went to update the Chart Widget, I noticed Sheet Summary wasn't there as an option. Is it possible using another method to automatically update a Chart Widget on a Dashboard? Preferably with the Move Row Automation, as we're already working with that in this Sheet.
-
UPDATE 2: Solved my second issue as well! Don't you love it when you make a thread for no reason.
I used Sheet Summary's again, then put those results into a separate columns within that sheet, then used those columns for reference with the Chart Widget. Works beautifully!
-
Hi @celtics345
I'm glad you figured it out! Thank you for updating the thread with your solution. 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!