Report with multiple sheets

Robin Liebman

Hi Smartsheet community, I am working on a report that compiles data from multiple sheets in a single folder. New sheets are added daily. Is there a way to automatically have the sheets selected update for the new sheets added daily instead of manually adding them? Thanks

Genevieve P.

Hi @Robin Liebman

What I would suggest doing in this instance is to set up a Workspace to hold all of your sheets. Then instead of adding the sheets to a Folder, add them to this Workspace.

If you select a Workspace as the Source for your source sheet in a Report, this Report will then automatically include any new sheets!

See the note in this article: Select Source Sheets for Report Builder

Cheers,

Genevieve