Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to create two dependent single select fields to determine the contents of a third field

Topic Labels: Formulas
154 2
Showing results for 
Search instead for 
Did you mean: 

I’m having trouble figuring out how to do a formula for dependent single select fields.

This formula will be used in a form for field technicians for a construction company.

The first single select field will have the choices: Product A, Product B, Product C

The second field will have the choices: Variation 1, Variation 2

airtable test

Any help with the formula below is greatly appreciated!

airtable test 2

2 Replies 2

Hey Paul,

So you’re trying to display Product + Variation?

You can concatenate them with the & symbol or with CONCATENATE

Your formula will be:

Product & Variation


For dependencies on whether they choose Product A or Product B, you will could use a SWITCH formula like this: