Hey all-
See equation below to hide “address 2” if blank and also show entire address in a single line. Good for PDFs and non-html uses.
CONCAT({Address - Address},CHAR(44),CHAR(32),IF(LENGTH({Address - Address 2}),CONCAT({Address - Address 2},CHAR(44),CHAR(32),{Address - City},CHAR(44),CHAR(32),{Address - State},CHAR(32),CHAR(32),{Address - Zip}),CONCAT({Address - City},CHAR(44),CHAR(32),{Address - State},CHAR(32),CHAR(32),{Address - Zip})))
Adam