Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Return a numerical value based on a Single Select Dropdown

Topic Labels: Formulas
Solved
Jump to Solution
151 3
cancel
Showing results for 
Search instead for 
Did you mean: 
urnbis8786
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 300, etc. Would some amazing wizkid be able to help me with that?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

If you only have a few items in your single-select field, you could do that with a SWITCH formula:

SWITCH(
{Your Single Select Field Here},
"Option Zebra", 250,
"Option Lion", 300
)

However, if you're going to have more than a few options, your best bet is to create a new table of products, where you would create fields for the product name and the price.

Then, back in your original table, you would create a linked record field that links to the table of products. Then, you would create a lookup field that looks up the price from the table of products.

I discuss linked record fields and lookup fields more in depth in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning. Note that this course is many years outdated at this point, but the key concepts of linked record fields and lookup fields still apply.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

If you only have a few items in your single-select field, you could do that with a SWITCH formula:

SWITCH(
{Your Single Select Field Here},
"Option Zebra", 250,
"Option Lion", 300
)

However, if you're going to have more than a few options, your best bet is to create a new table of products, where you would create fields for the product name and the price.

Then, back in your original table, you would create a linked record field that links to the table of products. Then, you would create a lookup field that looks up the price from the table of products.

I discuss linked record fields and lookup fields more in depth in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning. Note that this course is many years outdated at this point, but the key concepts of linked record fields and lookup fields still apply.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

urnbis8786
5 - Automation Enthusiast
5 - Automation Enthusiast

That's awesome Scott, thanks so much for the amazingly prompt reply! For this scenario the SWITCH option works really well!

ScottWorld
18 - Pluto
18 - Pluto

You're welcome! Glad I could help! 😀