I am experimenting with the Sights feature, and attempting to have my dashboard update whenever a new web form is submitted. We have some metrics that are manually updated every week, and I'm hoping to auto-populate an overall view.
However, a new form submission doesn't update any of the numbers in my Sight, they are stuck on the old numbers even though there are new, updated numbers in the sheet & cells I specified. I'm not sure why not. Any insights?