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

p_bureau

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.

Shaine Greenwood

Hi Paul,

It sounds like odd behavior and may be a bug. Please reach out to our Support team directly and troubleshoot this with them. They can determine whether this is a bug and work with you and our Development team to solve the issue.