Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

JOIN only if cell is not blank

✭✭
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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions