formulas within the Content Calendar

Grace_J_Dravenack32331

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)

Andrée Starå

Hi Grace,

It happens because of the TODAY function in the formulas. That makes the starting point to this year.

I'll have a look at the template and get back to the post.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Here you go!

Did it work?