Skip to main content

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!

 

 

 

 

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.

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}&" - ", "")

 

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

Reply


Terms & Conditions