-
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…
-
On Time and Past Due Formulas
Hello, I am trying to create a formula in Smartsheet that replaces a formula we are using in Excel that turns a cell red or green if the date entered is before or after a referencing cell date. If that makes sense. So – If the Review SOW date cell in a column is in the past and the Review SOW Complete cell is blank, that…
-
Count Ifs Specific Year
I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024. =COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 2024) this is what i have (primary column is referencing the word bidding). I am pretty sure it has something to do with the…
-
Merged: Please Remove Cross-Sheet Reference Limit
This discussion has been merged.
-
Streamline Sheet Reference Manager
I just went through an update where I needed to manually add 3 new sheet references to 26 Stakeholder Registers (78 total). I wish that after you click Insert Reference, the Sheet Reference Manager dialog box would remain open.
