Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculate total based on Multiple Select input

Topic Labels: Formulas
Solved
Jump to Solution
2222 2
cancel
Showing results for 
Search instead for 
Did you mean: 
bedjik
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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
6 - Interface Innovator
6 - Interface Innovator

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