-
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…
-
Cross-Sheet MATCH INDEX ERRORS
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
-
leading numbers
I have a cell where different numbers are always entered. Most of the time, this field contains a leading 0. With a leading 0, the text is left-aligned, but with any other leading number, the text is right-aligned. I have a formula where this cell should be compared to another cell. However, this no longer works when the…