Skip to main content

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? 

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?

Reply


Terms & Conditions