Updating a reports format from the related smartsheets

Dan Blocker

I have a report that looks at 30 smartsheets for current task status. On each smartsheet I have conditional formating to change the complete lines color based on a date field and the current date. When I run the report and I know a line should have chane color but hasn't, I open the related smartsheet and the line color updates and thus the reports line color.

 

How can I force the 30 smartsheets to update their formating automatically, without opening each one individually, so when I run my report in the morning I can see proper colored lines?

 

Thanks, Dan

Kennedy Stomps

Hi Dan--

 

We don't currently have a way to automatically refresh all source sheets for a certain report, but I've added your vote for this to our enhancement request list. Our developers will consider this for a future update--we appreciate your input!

 

In the meantime, how are the source sheets organized? If they're all in your Sheets folder, you might consider grouping them into a specific folder within this main directory. When you leave the office at night, take a minute and close all of the sheets. Then, when you get in in the morning, open the folder and use the top level checkbox to select all sheets, right-click, and select "Open". This will re-open all of the sheets, forcing a refresh of the Conditional Formatting rules. Hope this helps!