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
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
------------------------------