Due Date Formula

CGrace

Someone recently plugged a formula, =MIN(CHILDREN), into the due date column of the sheet I maintain, which is causing the parent rows to have an incorrect, past-due due date. I deleted the formula and replaced it with the correct due date, but it seems the sheet automatically reverts back to the formula due dates. The resource management is not active. I don't know how to fix this.

James Keuning

Is the incorrect date only on the parent row? Or all rows? And are you saying that a cell with no formula in it is reverting to some other value after you manually update the cell?

Are there any automations running in this sheet?

CGrace

Yes, the incorrect date is only in the parent row. The parent rows had a formula which I keep deleting, but it keeps reverting back.

Paul Newcome

Have you double checked cell history and activity log?