Date Calculation \ Automated based upon cell value
Good day Everyone:
I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date.
trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops calculating if the actual finish date is populated. Doesn’t have to be both one or the other would be satisfactory.
Along with that if the State of the task is completed, is it possible for the Actual duration cell to recognize that and insert the date that it was flipped to “completed”?
Help Article Resources
Check out the Formula Handbook template!