Multiplication and addition in one calculation error
Hi , I want to add a percentage to one cost then add additional costs without the percentage. Have tried various setups with Unparseable every time. What am I getting wrong?!
=([valueA]@row *1.18, [valueB]@row, [valueC]@row)
=([valueA]@row *1.18), [valueB]@row, [valueC]@row
=(([valueA *1.18), [valueB]@row, [valueC]@row)
=([valueA *1.18), [valueB]@row, [valueC]@row
=([valueA *1.18), +([valueB]@row, [valueC]@row)
=[valueA *1.18, (+[valueB]@row, [valueC]@row)
=([valueA *1.18), (+[valueB]@row, [valueC]@row)
Answers
-
Hi @Sarah Hole,
The issue you're encountering stems from the syntax and structure of the formulas you're trying to create in Smartsheet. When you want to add a percentage to one cost and then add additional costs without the percentage, the correct formula structure is crucial to avoid the "Unparseable" error.
To achieve this, you need to ensure that your formula correctly applies the percentage increase to
valueA
and then adds the unmodified values ofvalueB
andvalueC
. The correct formula structure for this operation in Smartsheet should look something like this:=([valueA]@row * 1.18) + [valueB]@row + [valueC]@row
This formula does the following:
([valueA]@row * 1.18)
- This part calculates the increased value ofvalueA
by multiplying it by 1.18 (which represents the original value plus an 18% increase).+ [valueB]@row + [valueC]@row
- This part adds the values ofvalueB
andvalueC
to the result from step 1 without any percentage increase.
Each of the formulas you attempted seems to have syntax issues, such as misplaced parentheses, commas used incorrectly, or incorrect formula structures that Smartsheet cannot parse. Remember that in Smartsheet formulas:
- Every opening parenthesis must have a closing one.
- Operations within the formula should be clearly defined and separated by proper operators (like
+
for addition). - Commas are not used to separate different parts of a formula in this context; instead, use them within functions to separate arguments.
If you're still encountering issues, ensure that
valueA
,valueB
, andvalueC
are correctly named references to cells or columns in your sheet, and that they contain numerical values that can be used in mathematical operations.bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Yes ! Thanks that pesky little + sign was missing. Thanks so much!
-
Hi @Sarah Hole,
Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!