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 Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.