So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be built it is not feasible to manually re-point the widgets to the latest data. So I need a workaround. Given that the widgets are always looking at the same cells the question now becomes how to update those specific cells with the right data.
When the web form inserts data the widget does not look at the new rows it looks at those orginally selected.
