How do I create a formula when the complete date is entered, it will trigger the next start date?
I am trying to figure out a formula that when I actually complete something, it will trigger the next start date task.
I have start date, due date and complete date.
Start date would be 2/1/21, with a due date of 2/10/21.
I'm then filling in when the task is actually completed, 2/15/21, I would like the next start date to reflect a new date to start of 2/16/21. (instead of 2/11/21).
The above formula did not help me as I don't want to add days.
Thank you this would help a lot if there is a simple formula!
Help Article Resources
Check out the Formula Handbook template!