Sorry, I copied from the wrong part form the old thread. Below is from the latest document that we have been using. I did also add conditional formatting so the % complete would color code based on what value is entered.
It is a working task list, so as projects are completed, they are being deleted or replaced with new projects (sometimes by different departments - this is where the problem occurs), and new projects are being added to the end of the main spreadsheet. Thank you for looking into this and asking questions!
Bookmarks