My sheet gets data from a form and update requests, it rarely needs to be opened directly.
I have reports for open items and completed items. I have summary fields in the sheet that count and calculate late items.
The Dashboard has metric widgets that look at the summary fields and two report widgets.
The dashboard doesn't show current info unless I've open the sheet that day. Is that normal?
Help Article Resources
Check out the Formula Handbook template!