Multiselect and Substitute formula

[Bianca_Cadieux]

Hi,

Begginer here with formulas!

I imported a lot of data into my database. In a column box, for example, I have up to 10 different data, all separated by semicolons. My goal is to multiselect them, but I was told that I had to substitute the semicolons for something else for it to work.

I have tried the basic substitute formula, but clearly I am missing some information or understanding.

Thank you very much for your help!

[Kamille_Parks]

Bianca_Cadieux:

I have tried the basic substitute formula, but clearly I am missing some information or understanding.

It would help if we knew exactly what you tried and how it failed. All you do is add a formula field with SUBSTITUTE({field}, ";", ","), then convert the formula into a multi select.

Is that what you tried?

[Bianca_Cadieux]

This is what I tried, but it says : Sorry, there was a problem saving this field. Can’t save field because it causes a circular reference.

Is the problem the name of my column ?

[Kamille_Parks · Accepted solution]

You should have two fields you’re dealing with. The original field with the semicolons in it ({field}), and the formula field for the substitute ({formula}). Once you’ve converted the formula into a multiselect field you can delete the original.

[Bianca_Cadieux]

I’m sorry, I’m not sure I totally understand.

Here’s a preview of what I’ve been doing so far. As you can see, it changes all my data to another column I have.

[ScottWorld]

As @Kamille_Parks mentioned above, you need to create a brand new formula field, not customize your existing field.

[Bianca_Cadieux]

OH GOD, IT WORKS! Thank you so much for both your help!