Calendar with Multiple Years

jl

How do I make a calendar that shows multiple years on the same grid view? 

When I change the yellow box, it just changes the start date column, but none of the other columns so it doesn't start a new year. 

I'd like to create an on going calendar that shows multiple years on the same sheet. 

 

 

Isaac Jose

Hello jl,

Thanks for your post. It looks like you're trying to use the Annual Calendar by Day template with multiple years. This template is currently setup with a combination of formulas to populate the dates and weekdays based on the year of the date entered in yellow on Row 1 (Formulas https://help.smartsheet.com/topics/formulas-and-functions)

The easiest way that I've been able to bring multiple years into a single view is to create multiple sheets from the template, then use a Report to view all of the sheets at once (Create Reports https://help.smartsheet.com/articles/522214-creating-reports). However, Reports don't currently support Hierarchy, so you'll be unable to expand or collapse each month with this method.

Alternatively, you can try the steps below which will bring multiple years into the "Calendar Year 2018" sheet:

1. Use the template or copy your sheet to create a new sheet (Using Templates: https://help.smartsheet.com/articles/522123, Copy a sheet: https://help.smartsheet.com/articles/803778-copying-a-sheet)
2. In the new sheet, enter a 2019 date into the yellow Date cell in the first row. This should allows the formulas to update all of the dates in the sheet
3. Right-click the Activity column and select Collapse All to collapse all the rows (Using Hierarchy https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows)
4. Left-click on the Row Number at the far left of the sheet for Row 1, hold the Shift key, the right-click the Row Number for Row 337. Since the rows are all collapsed, this should highlight all of the rows in the sheet and open the context menu
5. Select Copy to Another Sheet from the context menu and select your original "Calendar Year 2018" sheet from the popup window and select OK (Copying Rows to Another Sheet https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet)

If you open your original sheet, you should see that all of the rows were copied and added to your sheet with 2019 dates. Note that these new rows will not contain the original formulas, so changing the new yellow Date cell for the 2019 section to a 2020 date will not update the rest of the dates and weekdays.

You should be able to repeat steps 2 through 5 for the years 2020 and 2021 as well. Please be aware that sheets do have a 5,000 row limit, and large sheets may experience slowness.

If you have further questions, I recommend submitting a support ticket through our Web Form at https://help.smartsheet.com/contact and linking the URL to this thread in your request to ensure that the next available technical support specialist can assist you. 

Kind regards,

Isaac J

Smartsheet Technical Support

Learning Center