Help

Re: Multiselect and Substitute formula

Solved
Jump to Solution
422 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Bianca_Cadieux
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions

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.

See Solution in Thread

6 Replies 6

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?

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 ?

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.

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.

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

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