This should be really basic but I can’t for the life of me figure out how to do it.
I have two 4 dates fields, planned start, actual start, due date and actual completion date.
I want to be able to update the actual start date based on the completion date of the previous task. Surely this can be done?
I am trying to write an IF formula that says
IF actual start date is greater than the planned start date return “delayed start”
and IF the actual start date is blank and the planned start date is greater than today, return “delayed start”