JOIN only if cell is not blank

BarneeL ✭✭
edited 12/09/19 in Formulas and Functions

Hi there,


Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank?

The contents of the other sheet is generated from a form (and being constantly updated), so referencing the entire column is the only option unfortunately.

It seems like it should be easy, but I am drawing a blank on how to do it.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!