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

p_bureau
p_bureau
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?

 

Thanks!

 

Paul B.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!