Way to work around 20 000 inbound cell links limit

Hello everyone,

We work with a big sheet in my organization and we will reach soon the 20 000 inbound cell links.

Do you know if there is a way to work around that limitation?

There are the options I explored

1- break down this big sheets in many smaller ones

2- give a try to data table in Smartsheet (does somebody experiment this function?)

3- instead of linking sheets directly in Smartsheet, I will use an external tool as Zapier or Make to synch the sheets together

Do you have any other suggestions for me or comments on these options I plan to try?

Thanks and have a nice day.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

The below works best if you have a unique id on every row:

You could create a helper text/number column on the source sheet(s) and use a formula to create a string of the data you want coming over, reference the unique id to pull this string over using a cross sheet formula such as INDEX/MATCH, then parse the string out.

A good example of this can be found here:

https://community.smartsheet.com/discussion/106300/extract-function-select-data-between-defined-tags

Julien Liboiron

Hi Paul,

Thanks for your help.

I will try it to lighten my sheets.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.