JOIN Function
I have followed all the instructions but really struggling with this.
I am trying to show items from several columns in Calendar View. I read this can be done using Join Function for the primary column. I used the same formula and was able to get it to work for two columns but when I attempted to add more I get an error.
Is there a limit to the number of columns you can join?
Thanks for your help!!
Answers
-
As far as I know, there doesn't seem to be a limit to a JOIN function, besides probably the max characters within a cell. But I may be wrong.
There's a limit though on what the Calendar View will display from the Primary Column. So I would advise you to not JOIN too many cells within your primary column.
Just out of curiosity, what kind of error are you getting from the JOIN function?
-
You are right, I just realized it won't show me the names on the calendar function. :( I am trying to display names on a calendar and the names are pulling from date lines within a sheet but would be from different columns. I don't think the calendar function is going to work well for me after all. Going back to excel, which is a bummer since I am working to move my sheets to SmartSheet.
Thanks!
-
Another option could be the Premium add-on, Calendar App.
More info:
Is that an option?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!