Clear check-box, without clearing associated Due Date columns
I'm setting up a sheet for reoccurring tasks that have different intervals.
I have a task column, interval column, last check, next check and a check- box.
When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column.
Is there a way to lock these dates, so that if the Checkbox is un-checked again either manually or automatically it doesn't clear everything? I've tried various formulas and automated workflows and I cant figure it out!
Help Article Resources
Check out the Formula Handbook template!