-
Merged: Remove Cross-Sheet Reference Limit
This discussion has been merged.
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Smartsheet Automation: Copy and Move Rows Limits
Hello all, this might be long winded, so apologies!!! My situation: I have a Smartsheet currently that holds all information for the current FY24 - Lets call it Sheet A. Coming in October, this information needs to archived off of this sheet to lets say sheet B so then Sheet A is blank and can intake FY25 information. I…
-
A sheet can include no more than 100 distinct cross-sheet references.
Is there any chance this can be increased in the future or has been in discussion? @Paul Newcome
-
Is it possible to reference another sheet's dropdown list in a formula?
I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the sheet, it populates a corresponding dropdown menu from another sheet. I completed the formula, but the dropdown menu does not…
-
Cross reference cell limitation of 100,000
Dear Smartsheet community, sorry for the lengthy message, but i wanted to be clear on what i am looking for. I have come across a lot of articles regarding the 100,000 record limit that you could reach with cross referencing between sheets. Nowhere I could see a clear formula to actually calculate this. Below is a formula…
-
Strategies for Managing Column Counting in Workarounds for Smartsheet Cross-Sheet Reference Limits?
Hello Smartsheet community, I've hit the limit of cross-sheet references allowed in Smartsheet, which has led me to adopt a workaround using formulas like =INDEX({Cross-Sheet Range}, MATCH(target_value, {Match_Range}, 0), column_index). This solution allows me to continue referencing data across sheets without adding more…
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet
-
Outbound Cell Limit - Who's Calling Me? (Outbound Cell References)
@Andrée Starå @Paul Newcome @Genevieve P. I understand from a different post that there is a 25 million limit on outbound cell references. Is there any method to find out who's calling the master lookup (source) sheet? A list of all sheets that reference the Lookup sheet? What about pivots and DataMesh - any ability to…
-
Cross Sheet Reference limitation with less than 60 references
Hi community. I'm trying to update formulas that came in a template because I find the naming scheme horrendous and off-putting. For those wondering, it's the "Staff Plan Management" template and the references are off by one digit across all W1 through W52 references, and it's irritating. For example, W1 will be "Project…
