-
Automation Saying Cell Limit, but not at limit
I have 62 columns and 7921 rows, meaning I have 491,102 cells, well under the 500K limit. However, I am receiving an error in an automation saying the target sheet has reached its limit. Does anyone know what is causing this?
-
Confused on Cross-sheet references
I have received the below message when attempting to create a Data Collection sheet: Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references. I have read the many different cross-reference post but still find myself confused. Here is my situation.…
-
Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row") Since getting the too many cell references error i deleted about half of the columns i had and…
-
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…
