Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Multiselect and Substitute formula

Topic Labels: Formulas
Solved
Jump to Solution
651 6
cancel
Showing results for 
Search instead for 
Did you mean: 

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!