Options
PJM ✭
12/14/22 in Formulas and Functions
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
0 · Share on FacebookShare on Twitter
Kelly Drake Overachievers Alumni
12/14/22 Answer ✓
Options
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
0 · Share on FacebookShare on Twitter
Kelly Moore ✭✭✭✭✭✭
12/15/22 Answer ✓
Options
@PJM
The unparseable is referring to the capitalized @ROW. This must be lower case. @row
Kelly
0 · Share on FacebookShare on Twitter
Answers
Andrée Starå ✭✭✭✭✭✭
12/14/22 edited 12/14/22
Options
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.
0 · Share on FacebookShare on Twitter
PJM ✭
12/14/22
Options
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))
0 · Share on FacebookShare on Twitter
Kelly Drake Overachievers Alumni
12/14/22 Answer ✓
Options
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
0 · Share on FacebookShare on Twitter
Kelly Moore ✭✭✭✭✭✭
12/15/22 Answer ✓
Options
@PJM
The unparseable is referring to the capitalized @ROW. This must be lower case. @row
Kelly
0 · Share on FacebookShare on Twitter
PJM ✭
12/15/22
Options
Thank You Kelly Drake & Kelly Moore; needed both suggestions to make it work!
Peter
0 · Share on FacebookShare on Twitter
Help Article Resources
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.2K Get Help
- 86 Global Discussions
- 90 Industry Talk
- 398 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 42 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 250 Events
- 13 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
