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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!