JOIN & CHAR and blank cells

Options
Bija
Bija ✭✭
edited 11/29/22 in Formulas and Functions

Hi - I am joining cells in a row that may or may not be populated with data. I need to pull them all into a single cell to map to a document. I've managed to pull them all in using this formula:

=JOIN([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, CHAR(1))

The issue happens with mapping. When a cell in the row is blank, I get a blank space in the document. I'm wondering if there is a way to omit the blank cells. I'm assuming some kind of nested IF, or better yet a simpler solution.

Thanks!

I actually managed to figure it out thanks to another user's question!

=JOIN(COLLECT([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, [PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, NOT(ISBLANK(@cell))), CHAR(10))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!