Hello everyone! Ive exhausted all my options. Hopefully the amazing Airtable Community can help me out…
So in essence the formula needs to get words from Column A and separate them with a vertical bar i.e. " | " and if a set of words like “New This Month” exists in column A the spaces need to be replaced by underscores.
In column A (Multiple Select) I have e.g:
Movie, New This Month, Entertainment
I need for column B (Formula) to produce the following with the data in column A e.g:
Movie | New_This_Month | Entertainment
Thank you in advance!