The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird.
Is this only on my copy of this sheet? I did delete it from my workspace and reload it to see if it would be fixed, but the issues remain.
- The INT() example does not actually use the formula
- The COUNT() example uses a range that goes from row 50 to row 24 (backwards? I guess this is OK)?
- The LEN() example seems like it should be getting the length of the phone number, but actually gets the length of the number "24" two rows below the phone number.
- etc.
More issues all the way down the template, including some that make it difficult to understand what the functions are meant to do. There are also some cell references that appear to be broken, and yet somehow actually still work?
Is this going to be updated any time soon? If so, please fix the references! Thanks! 😀