+4Hi,
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!
Best answer by Kamille_Parks11
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.
+27It 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?
+4It 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 ?
+27This 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.
+4You 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.
+35I’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.
+4As @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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.