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)
Answers
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Here you go!
Did it work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!