Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 01, 2021 07:26 AM
Hello,
I would greatly appreciate your help finding a solution to concatenate each of the following fields while ignoring fields which contain (just) the letter “X”. (I am using “X” to denote empty instead of leaving the filed empty).
FYI. This formula works for concatenating all fields while ignoring the blank ones.
IF({Login Companies}, " " & {Login Companies}) &
IF({Login Titles}, " " & {Login Titles}) &
IF({Login Persons}, " " & {Login Persons}) &
IF({Login Places}, " " & {Login Places}) &
IF({Login Differentiators}, " " & {Login Differentiators})
Many thanks!!!
Feb 03, 2021 01:33 AM
May something along the line of this?
IF({Login Companies}=“x”, blank(), " " & {Login Companies}) &
IF({Login Titles}=“x”, blank(), " " & {Login Titles}) &
IF({Login Persons}=“x”, blank(), " " & {Login Persons}) &
IF({Login Places}=“x”, blank(), " " & {Login Places}) &
IF({Login Differentiators}=“x”, blank(), " " & {Login Differentiators})
Didn’t test it, so no idea if it works :slightly_smiling_face:
Feb 04, 2021 05:33 PM
Hi there,
My apologizes for the delayed reply. I just this and test the formula. Unfortunately, it does not ignore those fields containing “X” however I will keep at it.
Many thanks for your time and effort!
Brian
Feb 06, 2021 10:53 AM
Just to be sure, you did use a capital “X” in stead of the “x” in the formula? You could think this is the most stupid question ever, but give me 1 cent for every formula that went wrong this way, and I’d be rich :grinning_face_with_sweat: