Creating Column with fomula using Control Center returns UNPARSEABLE

Cecilie · 07/03/23

Hello everyone!

I am running into an issue when using Control Center to create new columns with formulas across my active projects. I have already tried the column with the formula in one of these sheets and everything works fine there.

However, in testing and creating the columns using Control Center, it returns the UNPARSEABLE error in every cell. Strangely, if I delete the fomula and paste it in again, everything works as it should. Simply clicking Enter inside the cell does not work.

The column is set to a checkbox, which, using a fomula, checks for workdays. I have set the default cell fomula to =NETWORKDAYS(TODAY(); TODAY())

Seeing as the fomula works fine if I write it in manually, I am guessing the issue is with how the default cell value works, or how Control Center populates these cells. Though, I am fairly new to Smartsheet and Control Center, so perhaps I have overlooked something.

Any ideas?

Kaveri Vipat · 07/03/23

Hi Cecilie,

It seems you are using “;” this in your formula, can you try with this one =NETWORKDAYS(TODAY(), TODAY()).

I hope this works for you.

Cecilie · 07/04/23

https://community.smartsheet.com/discussion/comment/383498#Comment_383498

Hi Kaveri

This is how a formula has to be written with a Germanic language setting - a comma will not work. The fomula works, so unfortunately, that is not the problem.

Andrée Starå · 07/04/23

Hi @Cecilie

I hope you're well and safe!

Is the column locked?

I hope that helps!

Have a fantastic week & Happy Independence Day!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cecilie · 07/05/23

Hi @Andrée Starå

Thank you and you too.

I just tried testing it again with the column not being locked, and unfortunately the error still appears.

Andrée Starå · 07/14/23

@Cecilie

Happy to help!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Cecilie · 07/21/23

@Andrée Starå

How the column looks once created:

The fomula:

The same fomula working fine in a manually created column in the same sheet:

Paul Newcome · 07/21/23

Have you been able to do this before inserting a column with a formula through a global update?

I almost wonder if the back-end of Control Center is set to use commas instead and is causing the error because of that.

Cecilie · 07/24/23

@Paul Newcome

Changing to a comma within Control Center seems to have worked. Interestingly, it changes the comma to a semicolon after running.

Thank you for the help! This was very counterintuitive after finally getting formulas to work using semicolons and not commas 😅

Paul Newcome · 07/24/23

It does seem counterintuitive, but I'm glad we were able to get it sorted for you.

Creating Column with fomula using Control Center returns UNPARSEABLE

Answers

Help Article Resources

Categories