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.
Answers
-
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:
-
Hi Paul,
Thanks for your help.
I will try it to lighten my sheets.
-
