Skip to main content

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!

try converting the field to multi-select field.

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.


 

Try 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:

 

Reply


Terms & Conditions