Cells not multiplying correctly.

Geoff Baker
Geoff Baker ✭✭✭✭
edited 04/03/21 in Formulas and Functions
image.png

Hi,

I have two adjoining cells that are not multiplying correctly.

I have tried =[part qty] * [module type] and the formula returns "10" when it should return "20"

I have tried =[part qty]@row 8 [module type]@row and the formula return "10" when it should return "20"

Any help would be greatly appreciated.

[Module Type} is a Match with Index formula.

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Try:

    =Value([part qty]@row) * value([module type]@row)

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Try:

    =Value([part qty]@row) * value([module type]@row)

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter
  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Glad you found a solution. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!