I have a spreadsheet in which several fields are calculated field, they take a date and add X number of days based on the task SLA. This is to auto calculate where we are in the project. However I want the user to be able to enter in the actual date the task took place, and the other fields will auto update. However if the user were to accidently enter a date into the field, and needs to delete it, I would like to have the formula restored so the auto calculations can continue. Is this possible?
Bookmarks