Unticked boxes to trigger reminder dates
Options

pea.ccu49236
✭✭
In my project sheet, I have a Task Complete tick box.
I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date.
Is this possible?
Comments
-
=IF([Task Complete]1 = 0, TODAY(), "")
Will post todays date if the checkbox is empty. Change today() to whatever equation you want in that formula.