Im struggling to find how to integrate "null" into this formula, or maybe I am just doing it wrong. I am creating a field and wanted to concat 2 fields into it using the formula builder on Enterprise.

*Always copy name1_c**If name2_c exists - concat name1_c, name2_c*

So the field should always copy name1_c. If name2 exists, add a coma and name2_c. Keeping in mind that name2_c does not always exist and I must have a coma in the output.

Everytime I try this, I fail. Can I get some suggestions on the correct way to calculate this?

Hi Joshua Baer

I believe this formula does the job:

Kind regards