Document Builder - Mailing Label
I'm trying to build a mailing label from multiple columns and need a carriage return after each line. I have a formula I've written that works except that it doesn't suppress a null column and move the next line up.
Here’s the formula for Column 11:
=[Address 1]@row + CHAR(10) + [Address 2]@row + CHAR(10) + City@row + ", " + State@row + " " + Zip@row + CHAR(10) + [Address 2]@row + CHAR(10) + [Address 4]@row + CHAR(10) + [Address 5]@row + CHAR(10) + [Address 6]@row + CHAR(10)+ [Address 7]@row
In this example, if [Address 2] is blank, it would return this result in Document Builder:
City, State zip
Where Address 2 is a blank field and an empty space in the mailing label. I want to suppress Address 2 and everything else moves up.
Help Article Resources
Check out the Formula Handbook template!