JOIN Function

Mindy Schneider

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!!

David Joyeuse

Hi @mmschneider113031

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?

Mindy Schneider

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!

Andrée Starå

Hi @mmschneider113031

Another option could be the Premium add-on, Calendar App.

More info:

https://help.smartsheet.com/learning-track/integrations-and-add-ons/calendar-app

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!