-
Cell Referencing Report
A report which would provide the list of cells that are being referred from another sheet with details
-
Merged: Dynamically Update Column References
This discussion has been merged.
-
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…
