Refreshing Data after Form submission
I have a sheet which is populated daily using forms. The data from this sheet feeds into a dashboard which displays the number of entries that day. This metric comes from a cell that uses the "COUNT" formula to record the number of daily entries.
Everything with this works fine but the problem I have is that when a new form arrives, the data feeding into the dashboard doesn't update and the metric on the dasboard is not showing the correct value. To get the data to refresh to the dashboard I have to open the sheet and hit the save icon or just close the sheet again and the metric in the dashboard is refreshed and shows the correct value.
My question is, is there any way of getting a sheet to refresh automatically when a new form entry arrives thus keeping the metrics in the live dashboard correct.
Murray (CRL PLanning)
Help Article Resources
Check out the Formula Handbook template!