Join collect

Options

The formula works on my test sheet when I refer to columns as A, B, C etc. when I use the actual column names on my in production sheet the formula is not working - please help!!!

This works -

=JOIN(COLLECT(A@row:F@row, A@row:F@row, NOT(ISBLANK(@cell))), " - ")

These don't

=JOIN(COLLECT([BASEMENT SOUTH-NORTH]@row:[2ND FLOOR SOUTH]@row, [2ND FLOOR SOUTH]@row:[14]@row, NOT(ISBLANK(@cell))), " - ")

=JOIN(COLLECT([7]@row:[12]@row, [7]@row:[12]@row, NOT(ISBLANK(@cell))), " - ")

Columns -

Room # for Report

Drop downs columns for each region of the building.

many thanks EW

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!