Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Use a formula to generate values that are formatted like a multiple select list

Topic Labels: Formulas
441 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rohanmehta2000
4 - Data Explorer
4 - Data Explorer

I want to create an IF formula that converts a single select to a multiple select.

For example, in column 1 I want the value 'Primary Care Physician' to turn into a multiple selection of 'Internal Medicine Physician' and 'Family Medicine Physician'. It seems like the default formula output is a single line text, but is there any way to convert it to a multiple select list so that the data is actually stored in a list format? 

1 Reply 1

I'm afraid not.  As a workaround, you could use an automation to paste the formula output text of 'Internal Medicine Physician, Family Medicine Physician' into a multiple select field though?