Multiplication formula

Options
Stacy Stoffel
Stacy Stoffel ✭✭✭✭✭
edited 12/12/22 in Formulas and Functions

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?

Tags:

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 12/12/22 Answer ✓
    Options

    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

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 12/12/22 Answer ✓
    Options

    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

  • Stacy Stoffel
    Stacy Stoffel ✭✭✭✭✭
    Options

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

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Options

    HI @Stacy Stoffel,

    No problem, happy to help. Glad it worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!