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!
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:
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.