Simple Multiplication

LTSmartsheet

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.

Paul Newcome

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

Colleen Patterson

@LTSmartsheet

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.

LTSmartsheet

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...

Paul Newcome

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

LTSmartsheet

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

Paul Newcome

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

LTSmartsheet

That worked! Thank you so much!!!

Paul Newcome

Happy to help. 👍️