Hi,
Issue: Dashboard charts not updating automatically.
Source Sheet, Summary Sheet and Dashboard Setup:
Source Sheet: List of tasks, has (amongst other columns) [Frequency], [Status], [Due Date] and [Task Due Today] (Formula to determine if the [Due Date] is today's date).
Summary Sheet: Uses the Source Sheet as it's source. Has a list of dates that determine (1) Today's date and (2) the Monday to Friday dates relative to today's date. Countifs formulas to count tasks based on [Frequency], [Status] and [Due Date].
Dashboard: 4x charts that use the Summary Sheet as it's source.
When does the issue occur?
- When I update a task [Status] in the Source Sheet (e.g. from empty to "Yes" (green tick)) and save the sheet.
- Go to the dashboard and the errors are displayed / charts do not have any data.
How to 'get it to work':
- Go to the Summary Sheet.
- Wait for the formulas to update (I would see the values change)
- Save and exit out of the sheet.
- Go back to the dashboard. The charts will now start showing the data.
Would be good to get an idea of how to resolve this. Thanks!
Cheers,
Justin