Combines a range of cells into a string with optional delimiters between the values
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")
Sample usage
JOIN([Task Name]2:[Task Name]6, " - ")
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.