It would be nice if any new sheets added to folders after reports are created are automatically added to the report. As is now, I have to manually add new sheets and often forget to do this.
Sign in to see the current vote count, add your own vote, or leave a comment.
Not sure if this works in your use case, but you can have the source for a report be a folder, and not a specific sheet. Then any sheet added to that folder gets added to the report.
We use this a lot... i actually have portfolio reports pointed to entire workgroups, then filter based on the sheet name (in our case any sheet that has the words "work plan" in its name.
Be advised that it considers every sheet in that folder as connected to the report, even if the filter excludes it. So if there are 5000 sheets in the folder, but your sheet name filter reduces it to 3, it still tells you there are too many sheets. It works, and I havnt had any issues, but its probably not advised to point to a folder with more than the sheet limit.
Thank you for your comment. I don't name files with any consistent naming convention like that, but can see how that would be a workaround.
One edit to my comment. Apparently you can point it to a workspace and it works as i described. But pointing it to a subfolder does not.
https://community.smartsheet.com/discussion/108796/pulling-report-data-from-a-folder-of-sheets
Similar situation for me. I have a "2025" folder within our workspace that we are constantly adding new sheets into, and creating a report based off that 2025 projects folder. But, I have to go into that report and reselect the 2025 folder everytime a sheet is added to get it to populate into the report. Doing this multiple thousands of times a year, gonna be quite the chore…
+1 upvoting. Anyone know if this is possible yet? Report-based report sources that auto-include new sheets added would be an incredible benefit. We have hundreds of sheets, it would massively reduce the maintenance required right now, support scalability and adoption at an organization level. Right now we are finding it too manual to maintain, error prone, when a sheet gets missed it causes frustration and loss of trust in reporting.
Upvoting. Totally agree, and it's ridiculous that this lack of basic functionality is still an issue in 2026. This throws me off all the time since it looks like the folder itself is selected, then find out later that it just selected the sheets within and ignores anything new added. I wonder how many votes we need to get Smartsheet to fix this embarrassing bug and align their software with UI patterns that have been established for decades. I'm sure their response will involve something about paying them more money for a premium add-on instead.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
