JOIN Function

Combines a range of cells into a string with optional delimiters between the values
Sample Usage
JOIN([Task Name]2:[Task Name]6, " - ")
Syntax
JOIN(
  • range
  • [
    delimiter
    ]
)
  • range
    The group of cells to join
  • delimiter
    —[optional]
    The value to separate the values in the range (e.g., a hyphen, comma, or space). If no delimiter is provided, the values from the range will be joined without spaces (e.g., "Task ATask BTask C")
Usage Notes

This is a good alternative to using + (the plus sign) to concatenate text.
 

Examples

This example references the following sheet information:

  Clothing Item Item Number Order Date Ship Date
1 T-Shirt C001 02/12/19 02/15/19
2 Pants C002 02/15/19 03/20/19
3 Jacket C003 02/20/19 02/27/19

Given the table above, here are some examples of using JOIN in a sheet:

Formula Description Result
=JOIN([Clothing Item]1:[Item Number]1, ": ") Returns the values in row 1 of the Clothing Item and Item Number columns, separated by a colon and a space T-Shirt: C001
=JOIN([Clothing Item]1:[Clothing Item]3, ", ") Returns the values in the Clothing Item column for rows 1
3, separated by a comma and a space
T-Shirt, Pants, Jacket
=JOIN([Order Date]3:[Ship Date]3, " - ") Returns the dates in row 3 of the Order Date and Ship Date columns, separated by a space, a dash, then another space 02/20/19 - 02/27/19

Still need help?

Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community