Skip to main content
Solved

Calculate total based on Multiple Select input

bedjik
Forum|alt.badge.img+7
  • bedjik
  • Known Participant
  • 12 replies

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?

2 replies

kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6002 replies
  • Answer
  • May 7, 2023

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
  • Author
  • Known Participant
  • 12 replies
  • 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