How to take Not Applicable and Completed item in consideration when calculating schedules?
Hi, I am working on building construction scheduling. In the template of my schedule, I have a list of items with predecessors. My questions, once I marked one item as N/A or DONE(two separate check boxes), how can I make the following items that have relation to this item to catch up? For example. let's say item A was on schedule for 6/1, and it's successor item B was on schedule for 6/2. If item A marked as N/A, then automatically, item B move up to 6/1. Also, if item A original finished date was 6/5, but when I marked it DONE on 6/4, it will change the completion date for item A and move up the item B's starting date.
I tried to use some formulas, but the predecessors, Start date, and Finished date are restricted and won't take any formula.
Any suggestions will be very grateful.