Calendar App multiple sheets

Kcreach · 08/29/19

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.

Andrée Starå · 09/01/19

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 · 06/25/21

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. · 06/28/21

Hi@Felicia Wilson

当你使用一个报告作为C的源alendar 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

这是一个你老板可以配置设置ure, 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 · 10/12/21

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

Genevieve P. · 10/13/21

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 tohideit if you don't want it visible. You can alsohideit 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 amoverow 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 · 10/27/21

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å · 10/27/21

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