Solved

Replacing a string with a dynamic string with another dynamic string

+4

Hi there, I am trying to output text that is taking the text from the lookup field "Name" and taking it away from a field called "Conversations"

Currently, I am trying to do this in a formula but for some reason it keeps saying #ERROR!

Best answer by mtrebinonixon

Try this formula:

SUBSTITUTE({Conversations}, {Name}&"", "")

By applyting the &”” you transform the lookup column from an Array to a String, and then it is usable by the Substitute formula.

Did this topic help you find an answer to your question?

Try this formula:

SUBSTITUTE({Conversations}, {Name}&"", "")

By applyting the &”” you transform the lookup column from an Array to a String, and then it is usable by the Substitute formula.

+4

mtrebinonixon wrote:

Try this formula:

SUBSTITUTE({Conversations}, {Name}&"", "")

By applyting the &”” you transform the lookup column from and Array onto a String, and then it is usable by the Substitute formula.

Thank you! This worked, is there also a way to remove “ - “ along with the {Name}?

For sure, you can add it to the “Name” field before substituting it.

In your case it should look like this:

SUBSTITUTE({Conversations}, {Name}&" - ", "")

+4

mtrebinonixon wrote:

For sure, you can add it to the “Name” field before substituting it.

In your case it should look like this:

SUBSTITUTE({Conversations}, {Name}&" - ", "")

Thank you so much! I really appreciate it

4 replies