Calculate total based on Multiple Select input

[bedjik]

Hello Everybody,

  I need some help with formula, so here is what I have, I have a "Multiple Select" field, lets say I have options like these there: Option A, Option B and Option C. Every option has its own price, let's say Option A is $10, Option B is $20 and Option C is $30. 

I have another field "Price", which is currently set up for "currency" and I manually enter the total there every time. So I want to use a formula to have a total sum of the options that I choose in Multiple Select Filed, any ideas? Thank you in advance

[kuovonne · Accepted solution]

You could use a formula field, but I recommend converting to a linked record field and using a rollup instead.

I wrote up both solutions here with screen captures and complete formulas in my Guide to Airtable.

[bedjik]

Thank you very much kuovonne with your help, both options are perfect, but I went with formula, as I need something simple with one view without creating additional table. Appreciate all the help and how detailed and thorough was your explanation