Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" . How many references we can do? I am using a sheet that has information of 13 sheets combine. (like a summary sheet). I like the summary sheet but the information in listing down and in my case I need it in a grid sheet.
Luis from PR
Hi Luis,
You can have 100 distinct - cross-sheet references.
More info: https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas
Here are some things to keep in mind as you work with cross-sheet formulas:
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
This is the most ridiculous limitation possible.
I just spent over 6 hours creating a massive dashboard for an extremely important project, and have run into the 100 cross-sheet references limitation with the need to create 8 more.
I cannot believe they tell you that the best practice in their system is to create a metric sheet for a dashboard and them limit you to 100 cross-sheet references. If this is not fixed ASAP then this product is essentially unusable for any enterprise level projects.
Sam,
I completely agree with you and your frustration. I build at an enterprise level as well and this limitation is forcing me to look for other solutions. Smartsheet has a lot of features, but still very elementary IMO.
Thanks!
I often hit this limit ... here's my work-around:
Albeit, a pain if you're not planning for this from the beginning!
@DWise
THANK YOU for this. YES definitely a PAIN when not planned for in the beginning!!!
I need a mental break and then when I come back I will tackle splitting my metrics sheet up to accomodate.
Hello All,
i have a similar issue. i have to create a sheet reference.
1.master sheet where i have to create formula.
2.sheet 2 has the dat we need to populate to master sheet.
when i am trying to create formula and refer to another sheet window, i cant find that sheet (i have admin access to that sheet)
please suggest.
Hi @Nilesh
Is it possible the sheet was renamed or created recently? It can take up to 10 minutes for the pop-up window to properly index new sheets or new names.
I would suggest waiting a few minutes and trying again - did that help?
Cheers,
Genevieve
I tried that. i just removed text what i was searching in screenshot. i am getting no matches found or getting list of sheets but i cant see the one i am looking for.
Hey @Nilesh
At this point, instead of searching for the name I would use the Sheet List Navigation.
First confirm where the second sheet is located (or even create a Folder and put it there to make it easy to find). Then click on the little "sheet" icon next to the Search icon to find it that way:
You can link in from sheets where you have at minimum Viewer Permission, so Admin Permissions are definitely enough.
If you still can't find it that way, can you confirm that you still have permissions on the sheet? Is it possible that this sheet was either deleted, or your access removed?
That perfectly worked. Thank you so much Genevieve :)
Same here and it's 2024 - years after this initial discussion was brought up (2020). Was hoping there was a better solution / improvement to this at this point bc I too just spent several hours developing sheets, reports and a dashboard and it is not reasonable, feasible or practical to parse out my source data into multiple sheets just to work around the cross sheet reference limitation. Finding that Excel actually has the ability to do what I'm trying to do for this particular effort and can do it MUCH more simply. This is super frustrating! If anyone has an update to this, I'd be thrilled to hear about it. Thank you!
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
