I have a project management sheet programmed with predecessors. Sometimes I need to add line items via web forms or "copy to" automation feature. Weh I add these lines, I need the new row to sort into place with the other dates (see images)
Image 1 - Sort order of operations - SITE NAME first, START DATE second
Image 2 - Unsorted row - sorts by SITE NAME, bit not by DATE
I am basically having trouble getting it to sort by the second feature, which is the date. I wnder if it is because I have predecessord programmed? Maybe I just need to manually move then into place after it gets addded?
Or I can let it stay at the bottom of the page and just pull it into a report and sort it from there.