Changing of a date once it has passed


Hello Smartsheet community,

I am looking for a formula where a cell automatically changes to the next date once the current day has passed. For example:

If the date cell currently has a "12/3/2022", I want to replace it with next month's "1/3/2022" in the same cell.

I am not sure if this would be an automation or something that you can do as a formula. Just wanted to have some insight. Please let me know at your earliest convenience. Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!