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…
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
