Dropdown list with numbers

Ewa Zlotkowska · 04/14/22

Hello,

I created some sheet that is filled by other users by form. Form is based os single select dropdown list, like this one below:

After submitting a form, there are some calculations made on those numbers.

Until yesterday numbers appeard in that format:

Now they appear in that format, so calculations cannot be made:

Something changed? What can I do to keep old formatting?

Andrea1 · 04/14/22

I also have the same problem

Andrée Starå · 04/14/22

Hi @Ewa Zlotkowska & @Andrea1

I hope you're well and safe!

If you haven't already, I recommend reaching out to the Smartsheet Support Team.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ataberk_teknekaya · 04/14/22

I have the same issue, i hope it is fixed

ataberk_teknekaya · 04/15/22

@Ewa Zlotkowska , @Andrea1

Hi all,

I have fixed it by changing my regional settings on smartsheet. I have been using Turkey region and we use comma for decimals. Just changed to United States and it worked

Ewa Zlotkowska · 04/19/22

Thank you @ataberk_teknekaya! Unfortunately it didn't work in my case.

Chemi Pérez · 04/19/22

Hello everyone! I have the same issue.

I hope it would be fixed as soon as possible. A lot of formulas are failing.

Andrée Starå · 04/19/22

Hi @Chemi Pérez