12

I have developed a web form for a sheet I am using to collect production data from our production lines.

I am then using a smartsheet sights to display production data on a dashboard I have published.

I may be wrong, but I think the sheet that the data is being sent to needs to be manually refreshed so that the sight will be continuously up to date?

Is there a way to automate the refresh function?

Thanks

Jon

Industry

Comments

Jon,

This is exactly what I did recently. (web form - production lines - display screen)

I installed an AutoRefresh extension through Google Chrome (or whatever youre using) and so far it seems to work perfectly! 

Yeah, this is a very annoying oversight, and I truly despise workarounds; though, I also thank you for the tip, Laura. :)

Smartsheet, please add my vote to this feature request.


How is it possible to have a functioning dashboard without sheets that are smart enough to keep updating daily (at a minimum), or, better yet, at preset intervals?

In reply to by Scott Willeke

Hi Scott, I understand the Dashboard refreshes automatically, but what about the source data sheets? 

I have grids that pull from other sheets and feed data to the Dashboards.  These grids contain a myriad of formulas that need to be refreshed in order to feed accurate, up to date information to my Dashboards. 

Since some of these sheets are automatically emailed out each morning, how do I ensure my source data sheets are updating when I am not logged into Smartsheet (ex. over night when my laptop is off)? 

In reply to by Jonathan

Hello Everyone - Just wondering if you were able to find a workaround to have the auto refresh feature for the source data sheet. I'm encountering an issue in triggering automated reminders that's based on a column "Current Date" which is formula driven. Unless I have the auto refresh enabled, I might have to think of some other means.

Appreciate your inputs !

 

With Regards

Sriram

In reply to by cheerfulsri

I have this same issue. Is there any update coming to smartsheet to have source data sheets update automatically so that formulas can update without the user actually going into the sheet?

I have found a workaround to this auto refresh issue. 

I created a free account with Zapier and connected my Smartsheet account.  I created a new sheet which I named "Refresh" and programmed Zapier to edit one cell in that sheet with a current time and date stamp each morning around 3am. 

Next I created a hidden column in each sheet that needs to be auto refreshed and used cell-linking to pull the time and date stamp from my "Refresh" sheet.  This way I only have one zap coming over from Zapier and cell linking flows that data to all sheets I have linked.  Since it is getting a current time and date stamp, Smartsheet sees this as data being changed and saves the changes to the sheet...Thus causing a refresh.  Since making this change, my reports that are emailed automatically each morning at 5am have had today's accurate information, instead of yesterday's old numbers.  

I'm still not sure why Smartsheet can't handle this type of functionality in-house.  It's unfortunate that I have to use a third party (Zapier) to force the refresh.  

I would not recommend using a browser extension to accomplish this, as many of the extensions I have researched seem to be laced with viruses or spyware.  

I hope this helps some of you!

Jonathan

2019 and we still do not have an auto re-fresh data?