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.

Updating a reports format from the related smartsheets

Dan Blocker
Dan Blocker ✭✭✭
edited 12/09/19 in Archived 2016 Posts

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!

This discussion has been closed.