Formula to pull selected text from a cell into a dropdown list.

damon.tackett

What I am needing to do is be able to pull specific pieces of information from Customer Order to either Austin# or Tulsa# those two columns are drop down lists with specific items. Austin# drop down list is two items BA1 and BA2. Tulsa# drop down list is BT1 and BT2. The Customer Order is a text field that can contain any information but will also include some combination of the items in the drop down list. So essentially what I am looking to do is a formula that if Customer Order contains BT1 it would select BT1 in the Tulsa, if it contains BT2 it would select BT2 or if it contains both it would select both. I was thinking using the drop down list in Austin# and Tulsa# columns would allow me to restrict what forms would be available in those columns. I have tried contains formulas but I can't seem to make it select in the drop down if there is more than one variable. I also tried creating an automation, but again can't make it reflect multiple variables.

I also tried removing the drop down list and just making Tusla# column a text column with these formulas but no success.

=IF(CONTAINS([Customer Order]@row, "BT1"), "BT1", " ") will work if there is only one variable.

=IF(CONTAINS([Customer Order]@row, "BT1"), "BT1", IF(CONTAINS([Customer Order]@row, "BT2"), "BT2", " ")) doesn't want to pull in both variables.

Monique Odom Stearn

Hello @damon.tackett,

Since you're working with multiple-select dropdowns, I would suggest using an automation. When you're working with a condition path in automations, the important thing to understand is that it will look for the first met condition and only move forward to the next condition path if the first one isn't met.

I would make two automations, one for Austin and one for Tulsa. You can set it up like:

Trigger: When rows are added or changed, when Customer Order changes to Any Value when triggered

Conditions: Customer Order contains BA1 and where Customer Order contains BA2

Change Cell Value: Austin# to BA1, BA2

add condition path

Condition: Customer Order contains BA1

Change Cell Value: Austin# to BA1

add condition path

Condition: Customer Order contains BA2

Change Cell Value: Austin# to BA2

Then you can repeat the above for the Tulsa automation.

This is telling the automation: Look to see if the customer order contains both. If yes, select both in Austin#. If not, look to see if it only contains BA1. If yes, select that. If not, look for BA2. If yes, select that.