Reports not capturing newly created sheet data from a "save as"
Pls see pic attached for details...The yellow reports live in the 'Exceptions Dashboards' folder (they are truly reports not dashboards). Each of the yellow Reports is linked to the entire "2023 Reviews" folder (pic #2) bc I check off the box for the whole folder in each individual yellow Reports' 'sheets' tab. Each month my user does a "Save as new" to copy the green "Monthly Review Folder Template" and saves it as a new month, in the 2023 Reviews folder. Green folder contains 2 sheets, 1 for New Acct Reviews and 1 for Closed Acct Reviews. My question is, if I'm saving the new copy of the template folder in the 2023 Reviews folder, which has been checked off as "should be included/linked" to my yellow Exceptions reports, why do I still have to go in and manually select the new month each month? Hopefully this is not too confusing...happy to provide more detail. Thanks in advance for any advice!
Best Answer
-
Reports have to be manually updated with new sheets when referencing individual sheets or folders. The only way a report will include new sheets as they are added is if you are referencing an entire workspace.
Answers
-
Reports have to be manually updated with new sheets when referencing individual sheets or folders. The only way a report will include new sheets as they are added is if you are referencing an entire workspace.
-
Ah, thanks so much! I'll adjust filters such that selecting the whole Workspace will weed out what is not needed. I appreciate it!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives