Ignore Blanks When Using Char(10)

Options

Hello, I am having display issues when using Join Collect and Char(10).

=JOIN(COLLECT([Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), [Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), @cell <> ""))

Results:

How do I get the blank to not display and have the 444 Site 4 to move up?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!