Multiplication formula
I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error.
Colum  Probability  with the percentage looks like this:
Column  Total Software TCV  with the value that needs to be multiplied against the percentage looks like this:
Column  Weighted TCV (Software TCV * Probability)  that I keep getting the Invalid Value Error:
Any ideas what I am missing?
Best Answer

Hi @Stacy Stoffel,
In your Colum  Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.
You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.
Then a simple =[Probability %]@row * [Software TCV]@row
should work for you in your Column  Weighted TCV (Software TCV * Probability) column.
If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.
=VALUE([Probability %]@row) * [Software TCV]@row
Hope this helps!
BRgds,
Ray
Answers

Hi @Stacy Stoffel,
In your Colum  Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.
You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.
Then a simple =[Probability %]@row * [Software TCV]@row
should work for you in your Column  Weighted TCV (Software TCV * Probability) column.
If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.
=VALUE([Probability %]@row) * [Software TCV]@row
Hope this helps!
BRgds,
Ray

Thanks Ray! Changing all the values to decimal points did the trick. I really appreciate your assistance with this!

HI @Stacy Stoffel,
No problem, happy to help. Glad it worked!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!