Simple Multiplication
Help! For some reason this simple multiplication is not working. I would like to multiply the Value (dollars) by the Workshare (%) and have the result return in the "Valued Based on Workshare" column.
Best Answer

Try removing the quotes and making them decimals then formatting the column as a percentage.
=IF(Role@row = "Prime", 0.80, 0.30)
Then you should be able to do the basic multiplication of
=Value@row * Workshare@row
Answers

Hi! What is the formula you are writing?
You should be able to get: =Value@row * Workshare@row to return a value in your Value Based on Workshare Column.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

I tried that, as well as =Value@row * (1+Workshare@row), and keep getting #INVALID OPERATION. I just tried to remove the formula that was in the "Workshare" column and hard code the percentage, and it worked. I guess I will just hard code the percentages then...

It sounds like we just need to adjust the formula in the % column. What is the formula you currently have in there?

The formula was =IF(Role@row = "Prime", "80%", "30%")

Try removing the quotes and making them decimals then formatting the column as a percentage.
=IF(Role@row = "Prime", 0.80, 0.30)
Then you should be able to do the basic multiplication of
=Value@row * Workshare@row

That worked! Thank you so much!!!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!