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?

Thanks!

Paul B.

Find more posts tagged with

Formulas

Reports

Support

IT & Operations

Cell linking

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.