Multiple Columns for Calendar View and App
Options
I am not aware of any way to pull in multiple columns into calendar view or within the calendar app. I think being able to do so would be beneficial as the only workaround that I have found is to create a report and embed multiple calendar views of the report into a dashboard to see all of the dates needed.
Tags:
Comments
-
Another workaround would be to use the sheet's primary column to gather and format the text you'd like to see on the calendar. For example, with the formula below in the primary column, I pull the task name (all caps to help it stand out) and several dates (each labeled within the formula).
=Task@row + " | " + "Submitted Date: " + [Submitted Date]@row + " | " + "Approved Date: " + [Approved Date]@row + " | " + "Phase 1 Due Date: " + [Phase 1 Due Date]@row + " | " + "Phase 2 Due Date: " + [Phase 2 Due Date]@row + " | " + "Phase 3 Due Date: " + [Phase 3 Due Date]@row
Hope this helps!
-
Researching the archives of Smartsheet Community, this is a very common issue/ask that I was also trying to solve. Kelly P.'s response is the only workaround I know but it's incredibly frustrating and I cannot use it in my circumstance. I have used the new Calendar app but when embedding into a dashboard or page like SharePoint, you have to log into Smartsheet EVERY TIME you visit the page which is not conducive for our busy hospitals. Would love to see the same technology be brought to the calendar view as in the calendar app. I will submit an enhancement request but looks like that's been happening for a while.
-
Can you describe how you are creating multiple calendar views within a single report. It seems like it has the same issue as a Sheet in which you can only have one calendar view at a time so I am interested how you are actually doing this work around.
-
I am sad to see that this request has been raised such a long time ago and still no progress.
The workarounds are not always applicable, especially when the sheet is connected to several others by workflows.
Are there any updates? Calendar view could be so helpful if it was possible to choose the displayed column!
