Cross-Sheet References Optimizations
Options
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.
Comments
-
I'm pretty sure they are increasing these limits! Looking forward to it.
Limit increase: 500,000 inbound cell links — Smartsheet Community
-
This comment specifically
-
@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 :)
-
I agree, I say that with fingers crossed that all limits are increased 😄
