Add 1 Month to Date for Multiple Years
PhilBakerOAC
✭✭
Hello
I am trying to build a formula that will add one month to each cell as shown in the sheet below. When a new year starts however I get the error indicated below. Any thoughts on how to fix this are appreciated!
Answers

You might want to consider reversing your sheet, so that columns are variables and rows are observations. Continuing like this will be hard work.

@BullandKhmer  thanks for the comment. Assume this is referring to a Pivot table via Pivot?

No, I mean starting from scratch with months as rows.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!