Self-updating report based on sheets in folder

Hi there,

Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report?

I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks like it just takes a static view of what is in the folder at the time of originally selecting it.

Alternatively, can I write a formula or cell reference that would automatically reference a new sheet? (Can use tools such as zapier to input a formula on a row once a new sheet is created).

Find more posts tagged with

Formulas

Reports

Cell linking

Comments

Andrée Starå

Hi Barnee,

Unfortunately, it's not possible at the moment with folders, (only workspaces work) but it's a great idea!

I also don’t think it’s possible with Zapier but I’ll get back to the post if I find a way

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Richard Rymill SBP

Barneei

What you ask for is a very popular requirement and the way to do it is to choose the Workspace that the new Sheet will reside in and yes, you will automagically see data from that sheet in Reports and Dashboards.

You are right you cannot do this using just Folders so have a think about how your smartsheets are set up to make life easier?

If you do need better automation then our API wizards can help? Our Project Initialiser app does similar things.

RichardR@smarterbusinessprocesses.com

unknown

This content has been removed.

Andrée Starå

Hi Chris,

@h1pst3r88

It should work as long as the sheets are located in the Workspace, and it's selected in the Report builder.

Doesn’t that work for you?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@h1pst3r88 I agree with @Andrée Starå. It should work regardless of whether a sheet is in a folder or not so long as the workspace is selected in the Report Builder. I have a few reports set up to look at an entire workspace and it is designed to pull new sheets as they are added within a folder within another folder within yet another folder, and it works just fine.

Daniel Z.

@Paul Newcome @h1pst3r88 @Andrée Starå Thanks for the discussion here. I just ran into the same issue. I have a variety of reports that use the same 2 folders full of sheets. I added a new sheet to one of the folders and none of the reports updated with the new sheet. Any updates or thoughts here? The way our infrastructure is set up, I don't want to select the entire Workspaces.

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…