JOIN function

Susan Swisher
✭✭✭✭✭✭
I am trying to JOIN 2 cells (same sheet) and it is returning an error:
=JOIN([# Dosed]2:[N]2, " / ")
Answers
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 506 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!