Skip to main content

Avoid a blank return when using concatenate on fields that may be blank


1 comment

  • Permanently deleted user
    Kimberly commented  ·    · Hi Nathan,

    To account for blank fields in a concatenated field, you would use a conditional statement. For example, the concatenated formula could follow the following syntax:

    if(isblank({Field 1}), "", {Field 1}) & " " & if(isblank({Field 2}), "", {Field 2})

    We are working with our product team to improve the way blank fields are used in concatenated formulas so the conditional statements are not needed. As new features are added, you can view them in our product release notes:

    Please let us know if you have further questions.

    Thank you,



Please sign in to leave a comment.

Powered by Zendesk