Ability to save as new more than 100 files so the interactions remain

Lori Hight · 12/09/22

Currently there is a limitation to save as new and/or copy only 100 files at a time. This means if you have a workspace with more then 100 files that need to interact with each other for the dashboards to remain intact, you can't do it. You would need to copy it in pieces and repick reports, data for widgets, etc.

rD7 · 07/21/23

I ran into the same issue. I have a folder with ~150 files and I am not able to copy the entire folder. Is there a way for me to copy, say 10 files, at once and paste it to a desired location? At present I can copy paste only a single file! To do this for 150 files feels very stupid! HELP!?

Chris Crazy Lab · 09/14/23

Please improve this, SmartSheet does not allow to copy more than 100 items from one workspace/folder to another and if we going to each folder, we have to move one by one item because Actions button is unable to move grouping, thank you

Marc Swenson · 09/25/23

The Workspace Copy API call only works with 100 or less objects in the source workspace. If you try to use the function call with greater than 100 objects, the call will fail.

This limitation was not stated in the API documentation, and I only figured this out after I’d developed a solution around the call.

100 objects is not very large for an application which is supposed to work at scale. Please consider upping that number to at least 1000, or come up with a solution to large workspace copies with pagination, similar to some of the other API calls.

Thank you, Marc

David_Sidon · 12/15/23

Same issue - I run a banking school(s) simulation that allows for 12 teams to compete - each team has 12 files, including master Smartsheet, reports and dashboard - with admin files, I'm at 130 and dead in the water to copy a "school" - awaiting a fix, please and eventual thank you

Dave Sidon, BanqueSIM

Jeremy Norman · 01/02/24

Smartsheet will not allow the copy/paste as new with workspaces greater than 100 items. When you have intricate automation and links, this process (Copy/Paste as New) is crucial to efficiency. Most companies need databases on a CY or fiscal year basis. Being able to develop workspaces and then copy/paste them as new for the next year is desperately needed.

This issue has been asked for since 2019, please vote!

Duplicating a Large Workspace

Paul Newcome

May 28, 2019

I've run into a bit of a problem...

I have build a rather large workspace. Everything ties together. It consists of 147 sheets, reports, and dashboards spread throughout various folders for organization. There is A LOT of cell linking and cross sheet references in various forms for various reasons.

I was recently informed that the workspace needed an overhaul. Some services we were tracking are being dropped, and new services are being added. This will affect literally every aspect of this workspace.

What I want to do is to "Save as new" the entire workspace, so I can do some preliminary testing on changes to make sure I have everything covered without affecting the current workspace as it will be in use until the new one is rolled out with the updates.

Here's the problem... You can only save up to 100 items. I have 147 not including folders.

If I save it in sections, I will have to go through and re-link everything and update all cross sheet references to the new sheets. Some of these sheets are close to maxing out on the cross sheet references. Re-linking and and updating everything to reference the new sheets will be a massive undertaking in and of itself, and I don't have that kind of time or energy.

Is there any way at all to get around this "100 item" limit so that I can take advantage of everything being automatically linked to the new sheets?

NeilKY · 12/13/24

that post is not set as a feature request… and to most people it would look like it was resolved.

LawrenceChow · 02/03/25

Upvote - this needs to be increased. Crazy it is limited to only 100.

EMMANUEL PETIN · 02/13/25

this is very big limitation of smartsheet; duplication is a key element if tool performance. Recently i spent 4 full days to fully reconfigure the new folder while in few seconds it would have been possible without this limitation

SmartsheetTG · 03/05/25

Please could Smartsheet look into this. It appears to be an issue affecting many users. I have a workspace containing 100+ files which are all linked to each other. This workspace needs replicating each financial year, and because of the file limit, it means that the files have to be transferred in tranches and then manually relinked to each other, which takes a full day of work. If the option was available to copy all files at once it would mean I could roll forward the files in a matter of minutes.

Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Sign in to submit new ideas and vote

Ability to save as new more than 100 files so the interactions remain

Idea Submitted · Last Updated 12/09/22

Comments

Duplicating a Large Workspace

FAQs and Guidelines for posting Product Feedback Ideas

Quick Links

Categories

Trending Ideas

Organising Structure For Automations

Restrict dropdown options as an option for forms

Dark mode