Suggestion for API/workarounds/Add-Ons to copy a large folder/folder size limitations?

01/01/22
Answered - Pending Review

I am trying to copy a Folder and stumbled into the 100 Item copy maximum (uhh....there are so many size limitations using this platform).

I reduced the # of items in the Folder to 59. When I am trying to copy it, it's timing out each time. I have tried over a couple of days to make sure there wasn't a server issue, but no luck. The Sheets in the Folder are very large, and I assume that is why it's timing out. 

Does anyone have any API/other workarounds to get around either the 100 item copy maximum or copying a Folder that contains large items in it?

Other Note: I do have a Support ticket into Smartsheet, but based on past experience, that will not be useful. And I have put in an Enhancement Request to allow more items to be copied at one time.

Answers

  • Hi @Kayla,

    Since you have already raised an enhancement request to expand the maximum of 100 items announced in this article and you have opened a new ticket to investigate your current road-block when copying 59 folders, I'd suggest to go with what support advises in this case as that doesn't look like the expected behavior.

    I hope this can be of help.

    Cheers!

    Julio

  • Hey Kayla. If you're running into large load issues like that, have you considered... folderception?!

    Create Folders within the Folder you're wanting to move, move your items into those folders.

    Then for the API stuff, create a NEW folder, then copy the smaller folders individually to that new folder? Tedious workaround, but hey, it just might work.

    Just throwing that out there as an idea. Sorry you're running into issues. If you discover a workaround (or whatever SS gives you), post it here for anyone's sake who's looking into a similar issue.

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    🧔 Brett Wyrick; your friendly neighborhood freelance consultant & Smartsheet helper.

    ❓ Need some more help? Want to automate systems outside of Smartsheet to connect to your Smartsheet? Want to automate your sheets to talk to one another easier? Other questions? Send me an email or connect with me on LinkedIn.‎

  • @Brett Wyrick, I wish this would work. All the Sheets are very interconnected, so they have to be copied together and at one time to maintain that relationship. I have gotten a response from Support and they’ve been working on it for a few days, no resolution yet on the timing out issue but I am hopeful.

    and for the 100+ item copy limitation, it seems like I am stuck. For now, I am going to pull out reports to get me under 100 and those source sheets will need updated and I think that can be done with an API, but if not, it’s a 2 hour ish task that I’ll need to do at the start of each year. Not ideal, but a workaround.

    Very hopeful SMartsheet has increasing all of these size, row, copy, column, reference, etc. limitations on their roadmap soon because this will be significantly more valuable to users than these new features.

    Thanks for your response and the idea!

  • @Kayla, wish I had a better answer for you. I agree they should increase the size of the limitations! There's a few things with the API that just seem oddly limited (like this) to just plain forgotten (like renaming Reports - I can rename every other item in a Folder, but I can't rename Reports using the API). Hopefully updates come soon, but there's other features I think they'll likely work on first, sadly.

    If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.

    🧔 Brett Wyrick; your friendly neighborhood freelance consultant & Smartsheet helper.

    ❓ Need some more help? Want to automate systems outside of Smartsheet to connect to your Smartsheet? Want to automate your sheets to talk to one another easier? Other questions? Send me an email or connect with me on LinkedIn.‎

Sign In or Register to comment.