I'm currently using SS to create a monthly tasks tracker. Each month the automation will copy last months data out into a separate sheet and then reset the original sheet with the next months dates.
I have a helper column tracking the next months due date of the task however there is not currently a way to copy that date into a different cell