Way to work around 20 000 inbound cell links limit

Julien Liboiron

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.

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. 👍️