Spreadsheet: 735335d1622865180-help-with-sorting-vaules-by-date-taken-from-table-worksheet
Sheet: Jobs

Job# | Address | Supervisor | Single/Double | Framer | Start | Finish | Truss delivery | Truss Install | [NAME] | Bricky | Actual start | Actual Finish | Top | Finish Top
1234 | 123 Sample St | Test | D | Mark | 2021-07-06 00:00:00 | 2021-07-11 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 |  |  |  |  |  |  |  | Help with sorting vaules by date taken from table
 | Test st 1 | Test | S | Ian | 2021-05-10 00:00:00 | 2021-05-14 00:00:00 | 2021-06-12 00:00:00 |  |  |  |  |  |  |  |  | Gday guys
 | Test st 2 | Test | S | [NAME] | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 |  |  |  |  |  |  |  |  |  | I have this table I have set up with the help of others on this site & im almost happy with everything. Just need one more thing
 | Test st 3 | Test | RB | Mark | 2021-05-13 00:00:00 | 2021-05-20 00:00:00 | 2021-06-12 00:00:00 |  |  |  |  |  |  |  |  | I add new jobs to this list as they come out and then allocate trades as required. I then pull the data for those trades and group it on a separate sheet
 | test st 4 | Test | D | Framer4 | 2021-05-21 00:00:00 | 2021-05-28 00:00:00 |  |  |  |  |  |  |  |  |  | The issue I have is getting those to be sorted in order by start date. I know that if I sort this table by the date then it will work but as I am pulling data for separate trades from separate columns I cant do that
 | Test st 5 | Test | D | Ian | 2021-05-18 00:00:00 | 2021-05-23 00:00:00 |  |  |  |  |  |  |  |  |  | Any ideas on this one?
 | Test6 | Test | S | Mark | 2021-05-24 00:00:00 | 2021-06-02 00:00:00 | 2021-06-14 00:00:00
 | [NAME] | Test | D | [NAME] | 2021-06-03 00:00:00 | 2021-06-11 00:00:00
 | Teest8 | Test | S | Ian | 2021-05-31 00:00:00 | 2021-06-12 00:00:00 | 2021-06-16 00:00:00
 | Test9 | Greg | RB |  |  |  |  |  |  | Raj | 2021-05-26 00:00:00 | 2021-06-03 00:00:00
 | Test10 | Greg | RB |  |  |  |  |  |  | Raj | 2021-06-09 00:00:00 | 2021-06-16 00:00:00
 | Test11 | Greg | RB | [NAME] | On Hold | 2021-06-10 00:00:00
 | Test12 | Greg | RB | Justin | 2021-06-26 00:00:00 | 2021-07-05 00:00:00 | 2021-06-30 00:00:00 | 2021-07-04 00:00:00 |  | Mehmet | 2021-07-20 00:00:00 | 2021-07-26 00:00:00
 | Test13 | Jake | D |  |  |  |  |  |  | Raj | 2021-05-20 00:00:00 | 2021-05-25 00:00:00 | 2021-06-04 00:00:00 | 2021-06-08 00:00:00
 | Test14 | Jake | D |  |  |  |  |  |  | Balvir | 2021-05-25 00:00:00 | 2021-06-01 00:00:00 | 2021-06-12 00:00:00 | 2021-06-15 00:00:00
 | 15 | Jake | RB |  |  |  |  |  |  | Mehmet | 2021-06-17 00:00:00 | 2021-06-25 00:00:00
 | 16 | Jake | RB |  |  |  |  |  |  | Mehmet | 2021-06-01 00:00:00 | 2021-06-08 00:00:00
 | 17 | Jake | RB |  |  |  |  |  |  | [NAME] | 2021-06-07 00:00:00 | 2021-06-18 00:00:00
 | 18 | Jake | D | [NAME] | 2021-06-03 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00
 | 19 | Jake | S |  |  |  |  |  |  | Raj | 2021-06-17 00:00:00 | 2021-06-24 00:00:00
 | 20 | Jake | S | Justin | 2021-06-15 00:00:00 | 2021-06-22 00:00:00 | 2021-06-21 00:00:00 | 2021-06-21 00:00:00
 | 21 | [NAME] | D |  |  |  |  |  |  | Balvir | 2021-05-10 00:00:00 | 2021-05-25 00:00:00 | 2021-06-02 00:00:00 | 2021-06-04 00:00:00
 | 22 | [NAME] | RB |  |  |  |  |  |  | Balvir | 2021-06-05 00:00:00 | 2021-06-11 00:00:00
 | 23 | [NAME] | RB | [NAME] | 2021-05-25 00:00:00 | 2021-05-31 00:00:00 | 2021-06-16 00:00:00 |  |  | Sandu | 2021-07-06 00:00:00 | 2021-07-10 00:00:00
 | 24 | [NAME] | RB | [NAME] | 2021-06-03 00:00:00 | 2021-06-09 00:00:00 | 2021-06-15 00:00:00 |  |  | Mehmet | 2021-06-28 00:00:00 | 2021-07-06 00:00:00
 | 25 | [NAME] | RB | [NAME] | 2021-06-01 00:00:00 | 2021-06-07 00:00:00 | 2021-06-11 00:00:00 |  |  | Raj | 2021-06-06 00:00:00 | 2021-06-13 00:00:00
 | 26 | [NAME] | RB |  |  |  |  |  | 2021-08-02 00:00:00
 | 27 | [NAME] | RB |  |  |  |  |  | 2021-07-27 00:00:00
 | 28 | [NAME] | D | [NAME] | 2021-06-29 00:00:00 | 2021-07-13 00:00:00 | 2021-07-15 00:00:00
 | 29 | Mitch | S |  |  |  |  |  |  | Sandu | 2021-05-29 00:00:00 | 2021-06-03 00:00:00
 | 30 | Mitch | RB |  |  |  |  |  |  | Raj | 2021-06-25 00:00:00 | 2021-07-05 00:00:00
 | 31 | Mitch | D | [NAME] | 2021-06-03 00:00:00 | 2021-06-16 00:00:00 | 2021-06-25 00:00:00
 | 32 | Mitch | D | [NAME] | 2021-06-11 00:00:00 | 2021-06-24 00:00:00 | 2021-07-08 00:00:00
 | 33 | Mitch | D | [NAME] | 2021-07-06 00:00:00 | 2021-07-20 00:00:00 | 2021-07-20 00:00:00 | 2021-07-20 00:00:00
 | 34 | [NAME] | RB |  |  |  |  |  |  | Balvir | 2021-06-16 00:00:00 | 2021-06-23 00:00:00
 | 35 | [NAME] | D | Adam | 2021-05-28 00:00:00 | 2021-06-10 00:00:00 | 2021-06-15 00:00:00 |  |  | Sandu | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | ? | ?
 | 36 | [NAME] | RB | [NAME] | 2021-06-11 00:00:00 | 2021-06-18 00:00:00 | 2021-06-15 00:00:00 | 2021-06-18 00:00:00
 | 37 | [NAME] | RB | [NAME] | 2021-06-23 00:00:00 | 2021-06-29 00:00:00 | 2021-06-25 00:00:00 | 2021-06-29 00:00:00
 | 38 | Jake | S | [NAME] | 2021-06-22 00:00:00 | 2021-07-05 00:00:00 | 2021-07-16 00:00:00
 | 39 | [NAME] | S | [NAME] | 2021-06-21 00:00:00 | 2021-06-25 00:00:00 | 2021-07-06 00:00:00
 | 40 | Mitch | D |  |  |  |  |  |  | Mehmet | 2021-07-07 00:00:00 | 2021-07-19 00:00:00 | ? | ?
 | 41 | Emi | RB | [NAME] | 2021-06-02 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 |  |  | [NAME] | 2021-06-29 00:00:00 | 2021-07-11 00:00:00
 | 42 | Emi | RB | [NAME] | 2021-06-17 00:00:00 | 2021-06-25 00:00:00 | 2021-06-17 00:00:00 |  |  | [NAME] | 2021-07-14 00:00:00 | 2021-07-23 00:00:00
 | 43 | Emi | RB | [NAME] | 2021-06-25 00:00:00 | 2021-07-06 00:00:00 | 2021-07-29 00:00:00
 | 44 | Emi | RB | [NAME] | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | TBC
 | 45 | Ray | RB | [NAME] | 2021-06-30 00:00:00 | 2021-07-06 00:00:00 | 2021-07-20 00:00:00 |  |  | Sandu | 2021-07-15 00:00:00 | 2021-07-20 00:00:00
 | 46 | Ray | RB | Cory | 2021-07-07 00:00:00 | 2021-07-14 00:00:00 | 2021-08-05 00:00:00 |  |  | Sandu | 2021-07-21 00:00:00 | CHECK