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

Data mesh: Merging between sheets
I have 3 sheets: 2 of them have their own forms to collect data, and 1 master sheet. The 2 individual sheets have questions which are similar to each other and questions which are completely different (they are 2 forms of questionnaires). The master sheet is used to merge the answers of the similar questions and all other…
Looking for solutions to share Dynamic Views
This discussion was created from comments split from: Dynamic View- Restrict view by current user.
Azure DevOps Dashboard
I’m trying to display my Azure DevOps dashboard within my Smartsheet dashboard. I attempted to use the Web Content widget by embedding the dashboard URL, but it didn’t work. My goal is to show the status updates and charts from Azure DevOps directly on Smartsheet. I’ve successfully used the Web Content feature before, so…