Lag between data in source and dashboard charts
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
Hi,
I have a similar problem but a much longer lag. I made a dashboard with several charts on it. Each chart is made from a report, which is sourced from a metrics sheet with not-so-complex formulas…Our employees enter data through forms, and the charts are generated automatically. The last piece of data is entered at 9 PM on a Sunday. I opened the dashboard, printed a PDF and shared it with my supervisors only to realize 3 out of 6 charts weren't up to date.Then I had to manually open all of the metrics sheets that weren't updating automatically, and only once I opened them did they refresh…Most of the data for those metrics sheets were entered hours before, only one piece of information was entered at 9 PM. I was doing this around 9:40 PM when it was refreshing in front of my eyes when I was opening the metrics sheets.
Is this normal or do I have too many formulas going on?Thanks
-
So what happens sometimes is that unless you open the sheet or have it make a call on the Smartsheet servers to update the information inside. I force this to happen is with an automation to record a date in a column called "Helper Date Column". I record an initial value in the column at the top.
To create this workflow:
- Create a column called "Helper Date Column."
- Record an initial value at the top (today's date).
- Select Automation > Create workflow from scratch.
- Title your workflow (for example, "Daily Update").
- Set the trigger to When a date is reached.
- Click on Run Once and change this to Custom > Repeat every Day.
- Select an early morning time for the trigger (e.g. 2:00AM).
- Configure a condition block for where the new date column is in the past.
- Set the Action block to Record a date in that new date column.
This should successfully update the sheet daily and pull all of the updated information into the sheet, which in turn will update the reports and dashboard. Hope this helps!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives