Skip to content

JOIN function

Susan Swisher

Susan Swisher ✭✭✭✭✭✭

10/07/24 edited 10/07/24 in Formulas and Functions

I am trying to JOIN 2 cells (same sheet) and it is returning an error:

=JOIN([# Dosed]2:[N]2, " / ")

Tags:

0 ·

Answers

Susan Swisher ✭✭✭✭✭✭

10/07/24

Now I get it; the formula works; however, the COLUMNS/CELLS need t be right next to one another?
=JOIN([# Dosed]4:N4, "/")
Any way that that can be altered?

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto p…
Answered ✓
Forms
Non-profit
functionality
Formulas and Functions
11
Apr 25, 2025
2
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only i…
Answered ✓
Formulas
INDEX
MATCH
Formulas and Functions
22
Apr 25, 2025
3
NETDAYS Formula Question
I have created a formula to track in progress orders by the number of days, =NETDAYS([Date Received]@row, TODAY()) I have the following columns created, Date Received, Date Completed, In Progress Days…
Answered ✓
Formulas and Functions
17
Apr 25, 2025
3