‘UNPARSEABLE’ Messages for Column Formula
Am new to Smartsheet
Have two columns; Duration Value and Work Effort
Trying to apply a formula to a third column, and then convert to a column formula, but keep getting ‘UNPARSEABLE’ Messages
The equation is follows: Work Effort / (Duration Value * 8)
Have tried every variation and function, but to no avail
_Peter
Best Answers

Unparsable is saying something is wrong with the syntax of your formula. Something in Work Effort or Duration is not a value so it's not multiplying correctly.
Also  the parentheses here are all out of sorts. You don't need to wrap parentheses around the numerator and then the denominator  order of operations will apply.
If you need to multiply the fraction by 8 use: =VALUE(([Work Effort]@ROW / [Duration Value]@ROW )* 8)
If you need to multiply the denominator by 8 prior to the divide use : =VALUE([Work Effort]@ROW / ([Duration Value]@ROW * 8))
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY business optimization product manager

Answers

Hi @PJM
I hope you're well and safe!
Can you share the actual formula?
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, 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.

As mentioned, tried many, but here are a few samples:
=VALUE ([Work Effort]@ROW / [Duration Value]@ROW * 8)
=VALUE (([Work Effort]@ROW) / ([Duration Value]@ROW) * 8))
=(([Work Effort]@ROW / ([Duration Value]) * 8))

Unparsable is saying something is wrong with the syntax of your formula. Something in Work Effort or Duration is not a value so it's not multiplying correctly.
Also  the parentheses here are all out of sorts. You don't need to wrap parentheses around the numerator and then the denominator  order of operations will apply.
If you need to multiply the fraction by 8 use: =VALUE(([Work Effort]@ROW / [Duration Value]@ROW )* 8)
If you need to multiply the denominator by 8 prior to the divide use : =VALUE([Work Effort]@ROW / ([Duration Value]@ROW * 8))
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY business optimization product manager


Thank You Kelly Drake & Kelly Moore; needed both suggestions to make it work!
Peter
Help Article Resources
Categories
Check out the Formula Handbook template!