Cell Reference Limits
Discussion List
- Is there any chance this can be increased in the future or has been in discussion? @Paul Newcome
- 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 s…
- 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 reac…
- 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_valu…
- Below is the source sheet destination sheet
- @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 look…
- 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 …
- 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 …
- 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 …
- 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 tha…