Trouble with !=BLANK()

#1

So I am trying to create a formula that would help me out w/ some grammar issues in my Page Designer.

Basically, if there is a contact in the secondary contact field named Gina Malone, I want the function to populate as “and Gina.” If the secondary contact field is blank I want the function field to remain blank. The below function does a great job of producing what I need when there is a contact in the secondary contact field, but always populates as “and” when secondary contact is blank.

IF({Secondary Contact}!=BLANK(), "and “) & LEFT({Secondary Contact}, SEARCH(” ", {Secondary Contact})-1)

#2

basically, you want IF({Secondary Contact}, "and “{Secondary Contact}, “”)

I’m ignoring the first name extraction for the moment. If you enter just a field reference, then it will evaluate it for ‘blank or not blank’

#3

Mike’s suggestion is mostly on point, but it has a syntax issue. Here’s the correction wrapped into (and correcting a separate issue with) your original formula:

IF({Secondary Contact}, "and " & LEFT({Secondary Contact},
    SEARCH(" ", {Secondary Contact})-1))
1 Like
#4

If you insist on using != BLANK() as sometimes you may need such comparison, try using !="" instead (2 double quotes with no space in between).

#5

Thank you! I’m new to this, so very much appreciate the help. Worked like a charm.