Forum Discussion

KristinBombaci's avatar
KristinBombaci
Qrew Member
6 years ago

Can I concatenate two fields into one when one field is blank?

I need to merge two field into one field if one field is blank. I have developed the below formula based on advice from this page but it has not been successful. If([MERRecord - MERS Analyst]="",[M...
Formulas and functions
KristinBombaci's avatar
KristinBombaci
Qrew Member
6 years ago
Thank you for your response Austin. I should clarify that I am trying to do this in a report, not in a form so the advice above would not apply. Do have a suggestion on a formula I can use in a report?

------------------------------
Kristin Bombaci
------------------------------
AustinK's avatar
AustinK
Qrew Commander
6 years ago
That makes it less confusing with what needs to be shown on the forms. The formula I gave should work for a report as well. You just need to create a new formula field for it. 

I can help explain what the formula from my last post is doing in words rather than code.

Basically it is "If [MERRecord - MERS Analyst] is equal to blank, show [PORecord - PO Analyst], otherwise show [MERRecord - MERS Analyst]."
  • KristinBombaci's avatar
    KristinBombaci
    Qrew Member
    6 years ago
    I created the new field and used the formula you provided and it works exactly as I was hoping it would! Thank you for all your help Austin!

    ------------------------------
    Kristin Bombaci
    ------------------------------