Envelope Addresses

In Panorama 6 you could have the following setup for addressing an envelope:

City, State, Zip

If Address2 was empty, City, State, Zip moved up under Address1 automatically and there would be no blank line. How do you get this to work in PanoramaX?

You could use the sandwich function, but I would be interested in a little bit more information about expanding in Panorama X

Another formula, would use arraystrip(.

arraystrip(Name+¶+Address1+¶+Address2+¶+City+", "+State+", "+Zip,¶)

No formula needed. Just use the “Collapse Blank Lines” option.

1 Like

Thanks Jim. That is exactly what I needed.