Feature Request: Choosing Cells for Dashboard Widget
Choosing cells to add to a widget is rather difficult. It would be nice to be able to use Control and Shift with the ability to select an entire row of cells when generating a "Metric" widget. When you click the row on the far left, you cannot utilize CTRL or SHIFT to select multiple rows.
Additionally, I have built in filters in sheets, and it would be nice to be able to "filter" the data in the widget creation screen for the "Metric" so that I can choose from a selected set of data, rather than having to choose from a hundreds of rows list.
Pulling in a report would also help solve the issue (and eliminate the need to update the data using a Metric widget if I wanted the data to consistently pull updated data), but as I have posted on a separate discussion, there are issues with reports pulling all of the formatting into the report (Granted the widget creation screen for Metrics also appears to have the same issue, not pulling in all of the formatting from a sheet).