Using "@row" reference with ";" as the separator
Hi the community!
I am using Smartsheet with French settings, meaning :
- the decimal separator (for numeric values) is ","
- the separator in formulas is ";"
When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",".
So if I modify the formula without changing back the separator to ";", I get a #UNPERSABLE. This is extremely time consuming...
Is this a bug or something I'm doing wrong?
Help Article Resources
Check out the Formula Handbook template!