Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Refreshing reports
Comments
-
When I make a change to a spreadsheet and save it and then open the report the report has updated with those changes so you shouldn't have to refresh.
-
Reports are a live document. They are constantly updating the information. The issue you will run into is that if the main sheet is open and the report is open at the same time the report will not update unless prompted to refresh. It is critical to not leave pages open that others have acess to. Reports and sheets that have multiple users or altering the same sheet will cause issues of overlaps in the saves and data become fragmented. I suggest that teams that use the reports down load them to excel and leave them open to refer to. Then login to the report make the changes and log out. Make sure to educate you team to recognize when other people are in the same sheet by seeing the marker on the heading when the sheet is open. Make sure to refresh often.
-
Also the report won't update if the original sheet hasn't been saved.
-
Great, thanks for your responses and help !!
-
I have my report set up to auto send every Monday morning to my staff so they have a to do list for this week. However, the report sent but was incorrect info. I have many formulas that apparently will not update unless I (or someone) first logs into the sheet. Is this true? The formulas won't update until someone logs in. I had the report set to send at 6 AM this morning as a test to myself and the data was incorrect. Once I logged into the sheet, everything updated.
-
I have this same issue as well. We have customer facing dashboards that show % complete on certain tasks. Unless the project manager goes into the sheet every day (which doesn't always happen) then the percent completes do not automatically update. Hopefully there is a fix for this coming?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives