Save as new//100 sheet limit - work around?

Hi -

Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace.

I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to go and relink a bunch of sheets/reports/dashboard widgets - which is not smart, Smartsheet!

Thanks,

Sean

Find more posts tagged with

Workspaces

Sheets

API and Developers

Comments

Paul Newcome

I recently ran into this as well. The only "workaround" was to group sheets/reports/dashboards together into folders based on what was linked to what.

I was then able to use the "Save as new" on the folders and had much less re-linking to do.

Depending on how everything is linked together, you may even be able to work it just right to where you won't have to re-link anything (maybe).

sean59916

Hey - thanks for the response Paul..unfortunately, all but about 5-6 are actually linked in some way! and believe me, I have tried all sorts of ways of managing things to rejig it..to no avail - alas my frustration!!

Paul Newcome

Ugh! I know the frustration.

Is it possible to break things down into sections by common links? Some way of breaking it down to where even though you have a bunch of sheets to link back together, it's the same link for group A and a common link for group B, etc?

While you would still be doing a fair amount of re-linking, if they are the same link it may go a bit faster.

I ran into the very same thing, and that's what I ended up having to do. I was fortunate in that I could break it down into two groups.

Group A had less sheets, but Group B had more links via cross sheet references.

If you have a cross sheet reference that is duplicated multiple times within a sheet, updating just one of those ranges will automatically update ALL of them on the sheet. For example...

{Sheet A Range 1} can be found 100 times on my sheet in various places in numerous different formulas. Same with {Sheet A Range 2} and {Sheet A Range 3}.

While that is a total of 300 links just on one sheet, all I need to do is update each range one time, and the other 99 for each will automatically update.

Because of this, I was able to group things so that even though Group B had A TON of cross sheet references (23 different ranges, each used more than 100 times in a sheet with 60+ similarly built sheets). That way I only had one instance of each range on each sheet to update instead of hundreds on each sheet.

ShelbyWarren

Running into this issue as well while creating a PMO workspace. I submitted an enhancement request on this as well. Does anyone have a workaround now?

Marc Swenson

Any Smartsheet reps have an ETA on this one? It’s been sitting as a feature request for over four years.

100 object is a pretty small number for workspaces, these days.

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…