Spreadsheet: 700698d1603294740-if-statement-using-1-0-within-formula-techneedexample
Sheet: FP_Confirmed&InProgress

60 Day Start Date |  |  |  |  |  |  |  | Total # Of Techs
60 Day End Date
 | C | D | E | F
District | Job Start Date | Job End Date | Job Status | Total Number of Techs | Job Duration | Job Duration Units | Days
District A | 2020-10-01 00:00:00 | 2020-10-31 00:00:00 | Cancelled | 1 | 30 | Days | 30
District A | 2020-10-13 00:00:00 | 2020-10-22 00:00:00 | CancelledWHours | 2 | 8 | Days | 8
District A | 2020-10-13 00:00:00 | 2020-10-26 00:00:00 | In Progress | 1 | 14 | Days | 14
District A | 2020-10-15 00:00:00 | 2020-10-22 00:00:00 | Sent To Billing | 2 | 9 | Days | 9
District A | 2020-10-16 00:00:00 | 2020-10-26 00:00:00 | In Progress | 1 | 7 | Days | 7
District A | 2020-10-16 00:00:00 | 2020-10-24 00:00:00 | In Progress | 2 | 7 | Days | 7
District A | 2020-10-16 00:00:00 | 2020-10-29 00:00:00 | In Progress | 1 | 9 | Days | 9
District A | 2020-10-17 00:00:00 | 2020-10-31 00:00:00 | PSI Confirmed | 2 | 16 | Days | 16
District A | 2020-10-19 00:00:00 | 2020-10-24 00:00:00 | CancelledWHours | 2 | 8 | Days | 8
District A | 2020-10-20 00:00:00 | 2020-10-26 00:00:00 | Entered | 2 | 6 | Days | 6
District A | 2020-10-20 00:00:00 | 2020-10-26 00:00:00 | Cancelled | 2 | 7 | Days | 7
District A | 2020-10-30 00:00:00 | 2020-12-17 00:00:00 | PSI Confirmed | 1 | 12 | Days | 12
District A | 2020-11-01 00:00:00 | 2020-11-07 00:00:00 | PSI Confirmed | 1 | 5 | Days | 5
District A | 2020-11-01 00:00:00 | 2020-11-14 00:00:00 | Cancelled | 1 | 8 | Days | 8
District A | 2020-11-02 00:00:00 | 2020-11-20 00:00:00 | PSI Confirmed | 1 | 14 | Days | 14
District A | 2020-11-09 00:00:00 | 2020-12-04 00:00:00 | PSI Confirmed | 2 | 22 | Days | 22
District A | 2020-11-15 00:00:00 | 2020-11-20 00:00:00 | PSI Confirmed | 1 | 6 | Days | 6
District A | 2020-11-16 00:00:00 | 2020-11-19 00:00:00 | PSI Confirmed |  |  | Days
District A | 2020-11-16 00:00:00 | 2020-11-24 00:00:00 | PSI Confirmed | 2 | 20 | Days | 20
District A | 2020-11-16 00:00:00 | 2020-11-21 00:00:00 | Tentative | 1 | 5 | Days | 5
District A | 2020-12-08 00:00:00 | 2020-12-17 00:00:00 | Tentative | 1 | 6 | Days | 6
District A | 2020-12-17 00:00:00 | 2020-12-21 00:00:00 | PSI Confirmed | 1 | 4 | Days | 4
District BE | 2020-10-18 00:00:00 | 2020-10-21 00:00:00 | PSI Confirmed | 2 | 4 | Days | 4
District BE | 2020-11-02 00:00:00 | 2020-11-06 00:00:00 | Tentative | 4 | 7 | Days | 7
District BE | 2020-11-16 00:00:00 | 2020-11-16 00:00:00 | Tentative | 4 | 1 | Days | 1
District BU | 2020-10-17 00:00:00 | 2020-10-21 00:00:00 | Ready To Review | 4 | 3 | Days | 3
District BU | 2020-10-18 00:00:00 | 2020-10-20 00:00:00 | Cancelled | 2 | 2 | Days | 2
District BU | 2020-10-19 00:00:00 | 2020-10-22 00:00:00 | PSI Confirmed | 1 | 2 | Days | 2
District BU | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | Tentative | 1 | 1 | Days | 1
District BU | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District BU | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District BU | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District BU | 2020-10-28 00:00:00 | 2020-10-31 00:00:00 | Tentative | 2 | 2 | Days | 2
District BU | 2020-11-01 00:00:00 | 2020-11-02 00:00:00 | Tentative | 1 | 1 | Days | 1
District BU | 2020-11-02 00:00:00 | 2020-11-03 00:00:00 | Tentative | 1 | 1 | Days | 1
District BU | 2020-11-02 00:00:00 | 2020-11-03 00:00:00 | Tentative | 2 | 2 | Days | 2
[NAME] | 2020-10-09 00:00:00 | 2020-10-21 00:00:00 | In Progress | 1 | 3 | Days | 3
[NAME] | 2020-10-13 00:00:00 | 2020-11-13 00:00:00 | In Progress |  | 30 | Days | 30
[NAME] | 2020-10-20 00:00:00 | 2020-10-20 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-20 00:00:00 | 2020-10-20 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-20 00:00:00 | 2020-10-20 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-20 00:00:00 | 2020-10-20 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | In Progress |  | 1 | Shifts | 1
[NAME] | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-11-01 00:00:00 | 2020-11-05 00:00:00 | Tentative | 8 | 4 | Days | 4
[NAME] | 2020-11-01 00:00:00 | 2020-11-04 00:00:00 | Tentative | 3 | 2 | Days | 2
[NAME] | 2020-11-02 00:00:00 | 2020-11-05 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
[NAME] | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-25 00:00:00 | 2020-11-27 00:00:00 | Tentative | 2 | 2 | Days | 2
[NAME] | 2020-12-01 00:00:00 | 2020-12-04 00:00:00 | Cancelled |  | 3 | Days | 3
[NAME] | 2020-10-16 00:00:00 | 2020-10-20 00:00:00 | In Progress | 4 | 4 | Shifts | 2
[NAME] | 2020-10-19 00:00:00 | 2020-10-21 00:00:00 | Ready To Review | 4 | 3 | Days | 3
[NAME] | 2020-10-20 00:00:00 | 2020-10-22 00:00:00 | PSI Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-10-20 00:00:00 | 2020-10-22 00:00:00 | In Progress | 3 | 1 | Shifts | 1
[NAME] | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
[NAME] | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 | Cust Confirmed | 4 | 1 | Days | 1
[NAME] | 2020-10-23 00:00:00 | 2020-12-31 00:00:00 | Cust Confirmed | 1 | 1 | Shifts | 1
[NAME] | 2020-10-25 00:00:00 | 2020-10-27 00:00:00 | Cust Confirmed | 5 | 1 | Days | 1
[NAME] | 2020-11-01 00:00:00 | 2020-11-15 00:00:00 | Tentative | 4 | 14 | Days | 14
[NAME] | 2020-11-01 00:00:00 | 2020-11-03 00:00:00 | Cust Confirmed | 4 | 2 | Shifts | 1
[NAME] | 2020-11-02 00:00:00 | 2020-11-04 00:00:00 | Tentative | 4 | 3 | Days | 3
[NAME] | 2020-11-03 00:00:00 | 2020-11-04 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
[NAME] | 2020-11-04 00:00:00 | 2020-11-05 00:00:00 | Cust Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-11-06 00:00:00 | 2020-11-07 00:00:00 | Cust Confirmed | 4 | 2 | Shifts | 1
[NAME] | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | Cust Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | Tentative | 4 | 2 | Shifts | 1
[NAME] | 2020-11-09 00:00:00 | 2020-11-12 00:00:00 | Tentative | 2 | 4 | Days | 4
[NAME] | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | Cust Confirmed | 2 | 1 | Shifts | 1
[NAME] | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | Cust Confirmed | 1 |  | Days
[NAME] | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | Tentative | 2 | 1 | Days | 1
District La | 2020-10-18 00:00:00 | 2020-10-23 00:00:00 | In Progress |  | 15 | Days | 15
District La | 2020-10-18 00:00:00 | 2020-10-21 00:00:00 | Tentative | 3 | 1 | Shifts | 1
District La | 2020-10-19 00:00:00 | 2020-10-30 00:00:00 | In Progress | 4 | 17 | Days | 17
District La | 2020-10-21 00:00:00 | 2020-10-22 00:00:00 | Cust Confirmed | 3 | 1 | Shifts | 1
District La | 2020-10-21 00:00:00 | 2020-11-06 00:00:00 | Tentative | 4 | 14 | Days | 14
District La | 2020-10-23 00:00:00 | 2020-10-30 00:00:00 | PSI Confirmed | 4 | 7 | Days | 7
District La | 2020-10-25 00:00:00 | 2020-10-27 00:00:00 | PSI Confirmed | 3 | 2 | Days | 2
District La | 2020-10-26 00:00:00 | 2020-10-30 00:00:00 | Tentative |  | 5 | Days | 5
District La | 2020-11-04 00:00:00 | 2020-11-11 00:00:00 | PSI Confirmed | 18 | 7 | Days | 7
District La | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | Cust Confirmed | 4 | 2 | Shifts | 1
District PO | 2020-10-20 00:00:00 | 2020-10-28 00:00:00 | In Progress | 4 | 2 | Days | 2
District PO | 2020-10-24 00:00:00 | 2020-10-27 00:00:00 | PSI Confirmed | 4 | 2 | Days | 2
District PO | 2020-10-25 00:00:00 | 2020-10-28 00:00:00 | PSI Confirmed | 4 | 2 | Days | 2
District PO | 2020-10-26 00:00:00 | 2020-10-30 00:00:00 | Cust Confirmed | 0 | 5 | Days | 5
District PO | 2020-10-26 00:00:00 | 2020-10-28 00:00:00 | Cust Confirmed | 2 | 2 | Days | 2
District PO | 2020-11-01 00:00:00 | 2020-11-02 00:00:00 | Tentative | 2 | 1 | Days | 1
District PO | 2020-11-25 00:00:00 | 2020-11-27 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
District PO | 2020-11-27 00:00:00 | 2020-11-29 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
District PO | 2020-11-30 00:00:00 | 2020-12-04 00:00:00 | Cust Confirmed | 4 | 5 | Days | 5
[NAME] | 2020-10-18 00:00:00 | 2020-10-24 00:00:00 | Cancelled | 4 | 7 | Days | 7
[NAME] | 2020-10-18 00:00:00 | 2020-10-24 00:00:00 | In Progress | 2 | 7 | Days | 7
[NAME] | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | Cancelled | 3 | 1 | Days | 1
[NAME] | 2020-10-19 00:00:00 | 2020-10-23 00:00:00 | Cancelled | 4 | 4 | Days | 4
[NAME] | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | Cancelled | 2 | 1 | Days | 1
[NAME] | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | In Progress | 2 | 2 | Days | 2
[NAME] | 2020-10-20 00:00:00 | 2020-10-22 00:00:00 | In Progress | 3 | 3 | Days | 3
[NAME] | 2020-10-20 00:00:00 | 2020-10-20 00:00:00 | In Progress | 1 | 1 | Days | 1
[NAME] | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | PSI Confirmed | 1 | 1 | Days | 1
[NAME] | 2020-10-22 00:00:00 | 2020-10-22 00:00:00 | PSI Confirmed | 1 | 1 | Days | 1
[NAME] | 2020-10-22 00:00:00 | 2020-10-22 00:00:00 | PSI Confirmed | 1 | 1 | Days | 1
[NAME] | 2020-10-23 00:00:00 | 2020-11-03 00:00:00 | PSI Confirmed | 4 | 12 | Days | 12
[NAME] | 2020-10-25 00:00:00 | 2020-10-31 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-10-26 00:00:00 | 2020-10-26 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
[NAME] | 2020-10-26 00:00:00 | 2020-11-09 00:00:00 | Cancelled | 1 | 14 | Days | 14
[NAME] | 2020-10-27 00:00:00 | 2020-10-27 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-10-28 00:00:00 | 2020-10-28 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-01 00:00:00 | 2020-11-03 00:00:00 | Cust Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-11-01 00:00:00 | 2020-11-07 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-11-02 00:00:00 | 2020-11-02 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-08 00:00:00 | 2020-11-14 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-11-08 00:00:00 | 2020-11-10 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | Tentative | 3 | 2 | Days | 2
[NAME] | 2020-11-09 00:00:00 | 2020-11-09 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-11-09 00:00:00 | 2020-11-12 00:00:00 | Cust Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-11-15 00:00:00 | 2020-11-21 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-11-16 00:00:00 | 2020-11-18 00:00:00 | Cust Confirmed | 4 | 3 | Days | 3
[NAME] | 2020-11-16 00:00:00 | 2020-11-16 00:00:00 | Cancelled | 1 | 1 | Days | 1
[NAME] | 2020-11-16 00:00:00 | 2020-11-16 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-16 00:00:00 | 2020-11-16 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-17 00:00:00 | 2020-11-17 00:00:00 | Cancelled | 1 | 1 | Days | 1
[NAME] | 2020-11-18 00:00:00 | 2020-11-18 00:00:00 | Cancelled | 1 | 1 | Days | 1
[NAME] | 2020-11-22 00:00:00 | 2020-11-28 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-11-23 00:00:00 | 2020-11-23 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-23 00:00:00 | 2020-11-23 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-11-23 00:00:00 | 2020-11-23 00:00:00 | Tentative | 4 | 1 | Days | 1
[NAME] | 2020-11-29 00:00:00 | 2020-12-05 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-12-06 00:00:00 | 2020-12-12 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-12-06 00:00:00 | 2020-12-08 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-12-07 00:00:00 | 2020-12-07 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
[NAME] | 2020-12-13 00:00:00 | 2020-12-19 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | Cust Confirmed | 1 | 2 | Days | 2
[NAME] | 2020-12-20 00:00:00 | 2020-12-22 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-12-20 00:00:00 | 2020-12-26 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-12-21 00:00:00 | 2020-12-23 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-12-27 00:00:00 | 2021-01-02 00:00:00 | PSI Confirmed | 2 | 7 | Days | 7
[NAME] | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | Tentative | 2 | 1 | Days | 1
[NAME] | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | Tentative | 2 |  | Days
[NAME] | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | Tentative | 1 | 1 | Days | 1
[NAME] | 2020-12-01 00:00:00 | 2020-12-02 00:00:00 | Cust Confirmed | 2 | 1 | Days | 1
[NAME] | 2020-12-06 00:00:00 | 2020-12-09 00:00:00 | Tentative | 2 | 2 | Days | 2
District San | 2020-10-16 00:00:00 | 2020-10-30 00:00:00 | In Progress |  | 2 | Weeks | 14
District San | 2020-10-18 00:00:00 | 2020-10-21 00:00:00 | In Progress | 4 | 2 | Days | 2
District San | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District San | 2020-10-28 00:00:00 | 2020-10-30 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District San | 2020-11-02 00:00:00 | 2020-11-16 00:00:00 | Cust Confirmed | 1 | 2 | Weeks | 14
District San | 2020-11-16 00:00:00 | 2020-11-16 00:00:00 | Cust Confirmed | 1 | 1 | Days | 1
District San | 2020-11-22 00:00:00 | 2020-11-24 00:00:00 | Tentative | 1 | 1 | Days | 1
District San | 2020-12-06 00:00:00 | 2020-12-08 00:00:00 | Tentative | 1 | 1 | Days | 1
District San | 2020-12-07 00:00:00 | 2020-12-08 00:00:00 | Cancelled | 2 | 1 | Days | 1
District Tul | 2020-10-15 00:00:00 | 2020-10-20 00:00:00 | Ready To Review | 1 | 3 | Days | 3
District Tul | 2020-10-20 00:00:00 | 2020-10-28 00:00:00 | In Progress | 2 | 8 | Days | 8
District Tul | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | In Progress | 1 | 1 | Days | 1
District Tul | 2020-10-25 00:00:00 | 2020-10-27 00:00:00 | Cust Confirmed | 14 | 2 | Days | 2
District Tul | 2020-10-26 00:00:00 | 2020-10-28 00:00:00 | Cancelled | 4 | 2 | Days | 2
District Tul | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | Cust Confirmed | 2 | 1 | Days | 1
District Tul | 2020-10-29 00:00:00 | 2020-10-31 00:00:00 | Cust Confirmed | 1 | 3 | Days | 3
District Tul | 2020-11-01 00:00:00 | 2020-11-01 00:00:00 | Cust Confirmed | 2 | 1 | Days | 1
District Tul | 2020-12-01 00:00:00 | 2020-12-01 00:00:00 | Cust Confirmed | 3 | 2 | Days | 2
District Tul | 2020-12-01 00:00:00 | 2020-12-01 00:00:00 | Cancelled | 2 |  | Days
District Tul | 2020-12-02 00:00:00 | 2020-12-03 00:00:00 | Cust Confirmed | 4 | 2 | Days | 2
District Tul | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | Tentative | 1 | 1 | Days | 1
District Tul | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | Tentative | 1 | 1 | Days | 1