The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
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?