Linking sheets
I'm creating a new smartsheet spreadsheet, I need to get data from another spreadsheet and make a link to update it in real time, but there is a limitation of 1000 rows per column. Can someone help me?
Answers
-
Hi @Gabriel Guerra You don’t have a limit of 1000 rows, you have limits of how many cells you can reference internal to your sheet (20M) and external (5M). There are ways to sneak around those limits but you’ll have to provide more context. Screen shots more in-depth description of what exactly you’re trying to do. Let us know!
-
Hello @Lucas Rayala I'm trying to create a link from this column to another spreadsheet, this is the row limit message. "You can only create 1000 links at once, select fewer cells and try again"
-
That limit is for linking cells at one time.
I would suggest creating cell links 500 rows at a time, so you know how many you've linked already and where to start again.
- In this pop-up window, instead of selecting the entire column, click the top cell then scroll down to the 500th cell.
- Create your link.
- Then in your current sheet, start another cell link in row 501, selecting rows 501 - 1000.
- Continue until all your desired rows have been linked.
Does that make sense?
If you have a Unique Column in both sheets, you could use a formula to match values across sheets and bring back related data instead. Here's more information: Formula combinations for cross sheet references
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives