I'm not exactly sure how to approach this problem. I am hoping it can be solved with calculated columns or thru a workflow. If it can only be accomplished with some advanced technique beyond the browser or SharePoint designer, I would appreciate being told that too.
My custom task list has about 30 list items. The tasks span about a 3 month time period. Predecessors are set on the tasks. They all have a start date and a due date. I have a calculated Duration column. There is a % complete or status column that I'd like to take into consideration so that completed items are not updated with a new start or due date.
I envision that if the start date of an item in the task list is changed. all items not completed who are predecessors would be updated with new start and due dates of the same duration. (It would also be ok if the updates had to be based on the due date instead of the start date if that made it easier to accomplish this need).
How can this need be accomplished? Thank you in advance.