Change Metric Widget references based on Checkbox

celtics345

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!

celtics345

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.

celtics345

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!

celtics345

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.

celtics345

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!

Genevieve P.

Hi @celtics345

I'm glad you figured it out! Thank you for updating the thread with your solution. 🙂