formulas within the Content Calendar


I am using a content calendar template. All the formulas were already a part of the standard content calendar Smartsheet. We noticed that since the new year (after January 2020), all the dates automatically shifted. The December 2019 parent row changed to December 2020. Please advise what I need to do to fix this calendar. The formulas are listed below. Is there a way to continue to use the same sheet for future dates? How do I avoid this issue from happening again? Thank you!

(1.) December 2020 (This was previously December 2019, but in the new year changed to 2020)

="December " + YEAR(TODAY())

(2.) January 2021 (This needs to be Jan. 2020)

="January " + (YEAR(TODAY()) + 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!