How can I generate the total based on 2 columns.

Terrif

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.

Carson Penticuff

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)])

Carson Penticuff

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)])

Terrif

That worked thank you so much for all your help!!

Carson Penticuff

No problem at all, I'm glad it worked for you!

Terrif

The formula you gave to put in the sheet summary how do you get it to do the same thing but for a diff column name?

Terrif

I figured it out!😁

Carson Penticuff

Awesome! One of the best ways to learn new things in Smartsheet is to modify existing formulas/solutions!