Formula for [date]+1 month?

Hi all,

If I was using excel, I'd use:

'=DATE(YEAR($A1),MONTH($A1)+1,DAY($A1))


However the equivalent smartsheet formula...

'=DATE(YEAR([Column2]12), MONTH([Column2]12) + 1, DAY([Column2]12))

...doesn't seem to be very "smart" at all, because it gets to December and can't handle the concept of rolling over into the next year the way excel does.


I've seen workarounds with lots of IF statements, but that's super unwieldy. Is there a more elegant solution?

Or can someone please advise how to request this gets developed?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!