Remove or Increase Cross Sheet Reference Limitations

Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form. Two days ago, I was adding the new info and cross-references for metrics and I reached the limit. I spent the last two days working non-stop to restructure the sheets to bi-pass the limits (on a holiday weekend). Now, I have approx 15 sheets to manage and still not sure I can make it past a couple of months for metrics/reporting. It is also important that I maintain past months/year's data for Joint Commission for each clinic (approx 125) - I created regional scorecards listing each clinic's results. The limitations just made managing the build much more inefficient and difficult and I am still worried I will reach the max soon, breaking everything again for a rebuild. This is not scalable. Thanks for your consideration.

Sign in to vote!

Find more posts tagged with

Sheets

Healthcare

functionality

On Wishlist

Enhancement Request

Comments

mkilroy

As a work around to the 100 cross-sheet references limit, I would like to propose that a cross-sheet reference can include multiple columns, but then you have the ability to select which of those columns you want to use in your formula.

To provide some context, I’ve created Capacity and Allocation (C/A) templates for 12 functional groups. In each template, the functional managers will enter in who is available to work on ‘x’ Project. I’m attempting to pull that information in from each C/A template using SUMIFS formulas. However, since each month, quarter, and half year requires a cross-sheet reference (about 20 total, including the Department and Project ID cross-sheet references), I was only able to pull in data for 5 of the 12 functional teams.

The formulas look something like this:

=SUMIFS({CA - PPM Jan 23}, {CA - PPM Department}, Department@row, {CA - PPM Project ID}, [Project ID]@row)

=SUMIFS({CA - PPM Feb 23}, {CA - PPM Department}, Department@row, {CA - PPM Project ID}, [Project ID]@row)

=SUMIFS({CA - PPM Mar 23}, {CA - PPM Department}, Department@row, {CA - PPM Project ID}, [Project ID]@row)

I’m curious if there is a way to reference the entire timeline (Jan 23 to H2 25) in a cross-sheet reference, but only sum the numbers from a specific month.

Thank you!

EmilyL

I love Smartsheet. I think it is a wonderful program.

In using Smartsheet for a couple of large organizations that have a high volume of transactions, etc., however, I have run up against the limits of Smartsheet so much that it comes close to negating all of the benefits.

I am sure I am not the only one who would appreciate the following limits be removed (I don’t know if it’s server space or what needs to be done):

500,000 cell limit for a sheet
100,000 cells referenced in a sheet (this comes up a LOT and to deal with it I end up making 20+ extra sheets to try to recombine data for reports that shouldn’t be necessary)
report limits—I’m less familiar with these but something like 2500 rows (large organizations have a lot of data)

And then the other big limitation is the processing time. When dealing with larger amounts of data it takes be 3-4 times as long as it should to complete tasks because every time I have to open a sheet or reference another sheet I have to wait for several minutes. It takes me less time to do the work in the sheet than it does for the sheet to open most of the time (and this is when I’m creating them)

Again, Smartsheet is a wonderful tool. It is my most frequent choice when I’m working with a company to organize their data and set up workflows, etc.. These are just things that would absolutely change things for the better.

Swicker

I absolutely ditto this! If Smartsheet wants to be used in large companies for wide-scale solutions - it will be critical to expand their cell limitations and speed up the processing time.

Riaan Kotze

Hi guys, kindly look into it to remove the cross-referencing limitation. I have to build a report over 12 months, reporting on each month, with quarterly reports as well as YT reports and the cross referencing is completely breaking my vibe..lol

Please I love SS and would really like to build this report on the platform.

Best regards,

Swicker

Adding my support for this improvement! Generally increasing the capacity of sheets to reference other sheets/reports/dashboards, etc. would greatly improve my ability to develop company wide Smartsheet solutions.

FeFagoni

I've a employee weekly survey running over SmartSheet Sheets, it's being very tough to create new data/KPIs as there is a hard limitation of Cross Reference Sheet, I suggest to at least double current number

Jessica Limke

I am currently trying to pull in data from multiple different sheets into 1 summary view sheet and hit the 100 unique cross-reference max limit, and I am not even halfway finished with my task. Can this limit please be removed or at the very least increased to a much larger number?

Paul Newcome

@Jessica Limke You can use a helper column in the source sheet to combine the multiple columns across each row into a single string (with a unique delimiter), pull this string over to the target sheet, then use a parsing solution to pull the individual data pieces out of the combined string. This will also help with sheet performance since cross sheet references can have a big impact on that.

Jubial

Second this - I've had many sheets completely break on me due to this. :(

RolandoN

I'd also like this.

Francisco

When adding a cross-sheet reference and selecting a column, the range should auto-name itself as opposed to being "GENERIC SHEET NAME 1" - I don't love having to click into the naming field to update (especially when I'm adding ~60+ cross-sheet references). It's monotonous.
When I click "enter/return" after selecting and renaming a field, the text box should accept changes. Currently, I can't click enter when doing a cross-sheet reference. I have to take my hands off my keyboard to click the "Insert reference" button... this messes up my workflow.
We should have an inventory of cross-sheet references to keep track of how many of our precious cross-sheet concerns we've used. Do you know how frustrating running into the max off-sheet reference limit is? We've had to scrap infrastructure build-out to correct this extremely disappointing limitation. The solution posed by SmartSheet support has been to "build additional intermediary sheets to spread out your cross-sheet references." Perfect, so now we can have five intermediary sheets (super confusing) that roll up into a consolidated sheet for reporting. Requires a bit of collateral build-out - not a good user experience at all.

Sometimes, I wonder if user experience and practicality were considered while imposing these limitations... I'm sure there's a back-end issue that forces this reference limitation...

I'm a bit concerned since it seems like basic functionality has been ignored to focus on new features and/or AI. Without basic functionality, it makes it hard to look forward to shiny new capabilities.

Samuel Mueller

I'm pretty sure they are increasing these limits! Looking forward to it.

Limit increase: 500,000 inbound cell links — Smartsheet Community

Samuel Mueller

This comment specifically

Francisco

@Samuel Mueller - it's not abundantly clear that this is referring to cross-sheet references. Looks like the number of cells that we can reference is increasing. I assume that the limitations there will be lifted as scalability solutions are implemented.

Looking forward to leveraging sometime next year - hopefully by that point we will have AI available to re-do the formulas/sheets we had to scrap :)

Samuel Mueller

I agree, I say that with fingers crossed that all limits are increased 😄

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.