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?
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"
Hi @Gabriel Guerra
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.
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
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Does anyone know why Editor cannot insert columns in a sheet? What's the harm in that? I can see why you might not want someone to delete or rename a column, but inserting a column seems harmless.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.