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

[Paul_Kariniemi]

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

Any help with the formula below is greatly appreciated!

[Hannah_Wiginton]

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

[Hannah_Wiginton]

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

Ideas for making IF/THEN statements to CONCANTENATE fields depending on "item type" Formulas

Sounds like you want to use SWITCH() instead of a nested IF() statement since you’re checking the same variable against multiple possible values: SWITCH( {Item Type}, "Watch", CONCATENATE({Field 1}, " ", {Field 2}, " ", {Field 3}), "Necklace", CONCATENATE({Field 4}, " ", {Field 5}, " ", {Field 6}), "3rd item type", CONCATENATE(...), "4th item type", CONCATENATE(...), "5th item type", CONCATENATE(...), "some sort of default value if none of the above item types match" )