Customize Calendar Display Column: select more than just the Primary Column

Restricting the Calendar to only display the Primary column is a problem. We need to be able to configure the Calendar View to show whatever column is needed. This is particularly useful if you are creating multiple calendar reports from one sheet with different titles needed.

Sign in to vote!

Find more posts tagged with

Calendar View

Reports

Idea Submitted

Comments

Amower

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.

Kelly P.

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

Calendar.PNG

Hope this helps!

BecH.

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.

Andrée Starå

Hi @RBro79

I hope you're well and safe!

As a workaround, you can combine multiple values in the primary column with a formula.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

RBro79

Hi @Andrée Starå

Thank you for the suggestion. Unfortunately, this sheet is referenced by multiple other sheets and reports. Changing it around to set up the primary column for the calendar view would not help. It would break several other things.

Andrée Starå

@RBro79

Ok. Yes, that wouldn't work.

Happy to help!

Shooter71

https://community.smartsheet.com/discussion/101268/multiple-columns-for-calendar-view-and-app

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.

Nina_1305

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!

CarolynD

We are working on several projects and would like to see what project is rolling out in our facilities. Unfortunately, the calendar view only allows for the Primary column. If other columns could be included it would help us greatly to know what was being implemented when and where and where we could fit in other rollouts. The only solution I see is to include additional information in the Primary column which we know not everyone is going to enter in the same format request. For example, Project Name - Facility, etc.

Andrée Starå

https://community.smartsheet.com/discussion/122221/calendar-view-allow-more-than-the-primary-column-in-the-view

Hi,

I hope you're well and safe!

I usually add a formula to collect multiple values from other columns in the Primary Column.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment help or answer your question? Please support the Community and me by marking it
💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!

CarolynD

Hello - I never thought of adding a formula to pull info into the primary column. I'll give it a try as it sounds promising! Thanks for the response.

Andrée Starå

https://community.smartsheet.com/discussion/comment/437040#Comment_437040

Excellent!

Happy to help!

✅ Remember! Did my comment help or answer your question? Please support the Community and me by marking it 💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!

Jon Barto

Another example of a great feature like calendar view…. However….

Many many many enhancement requests about adding additional column data to the view. But ZERO traction from smartsheet. Sometimes I wonder if whoever makes the choices on what to work on for smartsheet has ever used the program or even listens to its users. I have put in multi requests to add this feature over the past 6 years…. I also see there has been so many comments over the past years asking for this feature as well.

Sandra Murray

Typical, a basic request that after years and years, has no movement.

beckyb27

Agreed! and utilizing the primary column to make a formula doesn't work if you want to utilize parent/child relationships since those don't work in any other column.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…