How can I generate the total based on 2 columns.

Terrif ✭✭
edited 03/07/24 in Formulas and Functions

I need a part quantity x part price to equal a total on a sheet and I can't figure out the formula. The prices and parts amounts will be different each time. I've tried SUMIF and can't figure out what I'm missing.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    I would use this formula (as a column formula) for your total column:

    =[Part Quantity]@row * [Parts Price]@row

    You can then use this in your sheet summary field to get the total:

    =SUM([Total (qty x price)]:[Total (qty x price)])


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!