Calendar App multiple sheets

In the key features for Calendar App, it says "Create a Master Calendar - Combine multiple sheets into one master calendar." I can't figure out how to pull from multiple sheets. I currently have 1 sheet that has all our projects with a date range, and then I have a second sheet where holidays, vacation, etc. are entered. I need these both to pull into one calendar and preferable have the holidays, vacation, etc. balcked out.

Find more posts tagged with

Calendar View

Services

Integrations

Comments

Andrée Starå

Hi,

You'd use a report and then select that in the Calendar App.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Felicia Wilson

I created a report that contains 3 different sheets and I use that report in my calendar app. When my editors add new items, how do they specify which sheet the items should be added to?

Genevieve P.

Hi @Felicia Wilson

When you're using a Report as the source for the Calendar app, you can select what sheet new events are submitted to in the 6th tab of the configuration window, "More Options":

Screen Shot 2021-06-28 at 9.19.02 AM.png

This is a setting that you as the owner can configure, but Editors on the Calendar won't be able to select a different sheet for each item. It would be one sheet selection for all newly created events. Does that make sense?

If this doesn't work for you, we could potentially set up a helper sheet to include in your Report and house all new submissions from the Calendar app. There could be a drop-down selection in this sheet to identify which one of your 3 sheets the data should be copied over to, then you can set up a Copy Row workflow to move it to the right place after the submission has happened. Let me know if you'd like to see screen captures of how I'd set this up and I'm happy to help further.

Cheers,

Genevieve

RZInsler

Hi Genevieve - I'd love to see screen captures of the best way to do what you've described above please. Thanks!

Genevieve P.

Hi @RZInsler

No problem!

1 - Set Up

So here is my folder with 3 Sheets, 1 Helper Sheet, and the Report I'm using for my Calendar:

Screen Shot 2021-10-13 at 10.39.09 PM.png

2 - Helper Sheet & Helper Columns

In the Helper Sheet, I have identical columns to my actual project sheets, as well as one additional column. This helper column will be copied over to your other sheets so you will want to hide it if you don't want it visible. You can also hide it in the Report.

Screen Shot 2021-10-13 at 10.42.14 PM.png

The helper column is a dropdown, so your users can select what sheet the row should be sent to after the initial submission. Here I'm including it in the Report, but hiding it:

Screen Shot 2021-10-13 at 10.43.13 PM.png

3 - Configure Calendar App

Now, in order to set up your configuration in the Calendar App to have new events created in this Helper Sheet, we need to have a Test Row visible in the Report (or the App can't tell it's a sheet to select).

Add in any row, so it's pulled into the Report:

Screen Shot 2021-10-13 at 10.47.47 PM.png

Then add this as the sheet to use in your Calendar App for new events:

Screen Shot 2021-10-13 at 10.48.27 PM.png

So now all of your new events will come into this one sheet!

4 - Set up a Move Row Workflow in Helper Sheet

In my suggestion above I said Copy Row, but we actually want a move row workflow to move new submissions gathered into this intake sheet over to the correct project sheet.

This is what I built in my Helper Sheet:

Screen Shot 2021-10-13 at 10.53.00 PM.png

5 - Create Events!

Now you can create an event in the Calendar which sends the row initially to the helper sheet, but you can select what Project this should be sent out to from the dropdown!

Make sure you've included this dropdown in your Calendar Settings to show in the panel.

Screen Shot 2021-10-13 at 10.55.47 PM.png

After the automation has run, the row will appear in the correct sheet in your Report:

Screen Shot 2021-10-13 at 10.57.46 PM.png

Let me know if I can clarify anything further.

Cheers!

Genevieve

Jon E

I'm considering switching my team to Smartsheet from Asana. The above looks like a lot of work to pull due date data from multiple sheets and have them consolidated in some form in order to view what needs accomplished in a particular day. Asana can automatically produce that with one view. Any easier way to do that in Smartsheet?

Andrée Starå

Hi @Jon E

I hope you're well and safe!

There are multiple ways to solve it.

You could use a report instead, and it could be viewed as a calendar.

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Trending discussions

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…