Due Date Refresh Automation
I am wondering if the below function is possible for Smartsheet automation, and if so, how to set it up.
I have a due date of the 22nd each month and require the cell to refresh to the following due date once the current has passed. For example, if the current due date is 22/08/21, I need the cell to update to the 22/09/21 on the 23/08/21.
Any help here would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!