Skip to main content
Solved

Calculate total based on Multiple Select input

bedjik
Forum|alt.badge.img+7

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

Best answer by kuovonne

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.

View original
Did this topic help you find an answer to your question?

kuovonne
Forum|alt.badge.img+27

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
1 person likes this
  • bedjik
    bedjik
bedjik
Forum|alt.badge.img+7
  • bedjik
  • Known Participant
  • May 7, 2023

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

Reply


Most helpful members this week

Terms & Conditions