Hey,
I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!
Separating multiple data entries in field
+1
+17- Employee
you may have to convert the ; to , first. Remember, you can always "undo" if the conversion doesn't do what you wanted or restore a snapshot.
+31Try this:
1. Create a new formula field with this formula:
SUBSTITUTE(
{Refresh},
';',
','
)
2. It should now look like this:
3. Edit the new formula field and convert it to a multiple select field. It should now look like this:
Adam, Airtable Consultant - thetimesaving.company
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.