Total Price for multiple selections

Jordyn

I have an order form that has a drop-down column. Within that drop-down, you can select multiple things. I have a total of 35 items. How can I have Smartsheet total the cost for the selected items?

I have another sheet with all the tooling and cost.

DKazatsky2

Hi @Jordyn,

You can use something like this:

=SUMIF({Equipment}, HAS(Equipment@row, @cell), {Cost})

Hope this helps,

Dave