Using "@row" reference with ";" as the separator

edited 12/09/19 in Formulas and Functions

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?




Paul B.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!