Annual Calendar by Day Template

Tom Theado
Tom Theado ✭✭
edited 12/09/19 in Smartsheet Basics

Hi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the current calendar, the formula is not easy to update. 

Row 373 holds the date the year is generated from and starting in the next row would be 01/01/19 and it continues down the column. The formula in the cell is =$Date$373 - VALUE(YEARDAY($Date$373) - 1). When I try to copy this formula down the column it does not automatically change 1 to 2 to 3, etc. 

Also I need to the $DATE$373 in both locations.

Is there any easy way to update this formula for the entire year?

Thank you!

Comments