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.
Creating Column with fomula using Control Center returns UNPARSEABLE
Cecilie
✭✭✭
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?
Tags:
Answers
-
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.
Thanks,
Kaveri Vipat
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
-
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.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you and you too.
I just tried testing it again with the column not being locked, and unfortunately the error still appears.
-
Happy to help!
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
How the column looks once created:
The fomula:
The same fomula working fine in a manually created column in the same sheet:
-
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.
-
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 😅
-
It does seem counterintuitive, but I'm glad we were able to get it sorted for you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …