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?
