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:
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:
Comments
1 comment
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:
http://help.trackvia.com/knowledgebase/topics/55947-product-release-notes
Please let us know if you have further questions.
Thank you,
Kim
Please sign in to leave a comment.