Multiplication of a number and the result of a formula

Hello,

I'm trying to multiply a number and the result of a formula (also a number) but it says "INVALID OPERATION", any ideas please.


Thank you

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Jlind

    It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?

    Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:

    =Volume@row * VALUE([Baselined?]@row)

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Jlind

    Is it possible to share your formulas (both of them)? It is almost impossible without more information for the community to guess what might be causing your error. Also a screenshot of your sheet is always helpful (and usually helps get faster response from the community).

    With the additional info someone from the community will be glad to help.

    Kelly

  • Jlind
    Jlind ✭✭

    Sure,

    Please see below, the number is the first column and the formula is the second column.


  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Jlind

    It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?

    Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:

    =Volume@row * VALUE([Baselined?]@row)

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now