Spreadsheet: 762260d1641476204-modify-existing-if-and-iferror-formula-permit-register-example-6-1-22
Sheet: Job Register

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BUILDING PERMIT | OCCUPANCY PERMIT | Inspection Status | Job Notes | BUILDING PERMIT INVOICE | OCCUPANCY PERMIT INVOICE
ABC-21001 | Address 1 | Description 1 | Client 1 | 2021-04-01 00:00:00 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 001/001/001 | 2021-05-01 00:00:00 | 2021-05-01 00:00:00
ABC-21002 | Address 2 | Description 2 | Client 2 | 2021-04-02 00:00:00 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 001/001/002 | 2021-05-02 00:00:00 | READY
ABC-21003 | Address 3 | Description 3 | Client 3 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 001/001/003 | 2021-05-03 00:00:00 | FINAL
ABC-21004 | Address 4 | Description 4 | Client 4 | 2021-04-04 00:00:00 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 001/001/004 | 2021-05-04 00:00:00 | APPROVE
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 2021-04-09 00:00:00 | 001/001/005 | APROVE
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-04-06 00:00:00 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 001/001/006 | 2021-05-05 00:00:00 | PARTIAL OP
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-04-07 00:00:00 | 2021-04-09 00:00:00 | 2021-04-11 00:00:00 | 001/001/007 | 2021-05-06 00:00:00 | OP
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-04-08 00:00:00 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 001/001/008 | N/A | READY
ABC-21009 | Address 9 | Description 9 | Client 9 | 2021-04-09 00:00:00 | 2021-04-11 00:00:00 | 2021-04-13 00:00:00 | 001/001/009 | - | APPROVE
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 2021-04-14 00:00:00 | 001/001/010 | READY
ABC-21011 | Address 11 | Description 11 | Client 11 | 2021-04-11 00:00:00 | 2021-04-13 00:00:00 | 2021-04-15 00:00:00 | 001/001/011 | READY | READY
ABC-21012 | Address 12 | Description 12 | Client 12 | 2021-04-12 00:00:00 | 2021-04-14 00:00:00 | 2021-04-16 00:00:00 | 001/001/012
ABC-21013 | Address 13 | Description 13 | Client 13 | 2021-04-13 00:00:00 | 2021-04-15 00:00:00 | 2021-04-17 00:00:00 | 001/001/013 | READY
ABC-21014 | Address 14 | Description 14 | Client 14 | 2021-04-14 00:00:00 | 2021-04-16 00:00:00 | 2021-04-18 00:00:00 | 001/001/014 | 2021-05-04 00:00:00 | READY
ABC-21015 | Address 15 | Description 15 | Client 15 | 2021-04-15 00:00:00 | 2021-04-17 00:00:00 | 2021-04-19 00:00:00 | 001/001/015 | 2021-05-05 00:00:00 | PARTIAL READY
ABC-21016 | Address 16 | Description 16 | Client 16 | 2021-04-16 00:00:00 | 2021-04-18 00:00:00 | 2021-04-20 00:00:00 | 001/001/016
ABC-21017 | Address 17 | Description 17 | Client 17 | 2021-04-17 00:00:00 | 2021-04-19 00:00:00 | 2021-04-21 00:00:00 | 001/001/017
ABC-21018 | Address 18 | Description 18 | Client 18 | 2021-04-18 00:00:00 | 2021-04-20 00:00:00 | 2021-04-22 00:00:00 | 001/001/018
ABC-21019 | Address 19 | Description 19 | Client 19 | 2021-04-19 00:00:00 | 2021-04-21 00:00:00 | 2021-04-23 00:00:00 | 001/001/019
ABC-21020 | Address 20 | Description 20 | Client 20 | 2021-04-20 00:00:00 | 2021-04-22 00:00:00 | 2021-04-24 00:00:00 | 001/001/020
ABC-21021 | Address 21 | Description 21 | Client 21 | 2021-04-21 00:00:00 | 2021-04-23 00:00:00 | 2021-04-25 00:00:00 | 001/001/021
ABC-21022 | Address 22 | Description 22 | Client 22 | 2021-04-22 00:00:00 | 2021-04-24 00:00:00 | 2021-04-26 00:00:00 | 001/001/022 | APPROVE
ABC-21023 | Address 23 | Description 23 | Client 23 | 2021-04-23 00:00:00 | 2021-04-25 00:00:00 | 2021-04-27 00:00:00 |  | BP
ABC-21024 | Address 24 | Description 24 | Client 24 | 2021-04-24 00:00:00 | 2021-04-26 00:00:00 | 2021-04-28 00:00:00 |  | BP
ABC-21025 | Address 25 | Description 25 | Client 25 | 2021-04-25 00:00:00 | 2021-04-27 00:00:00 | 2021-04-29 00:00:00 |  | BP
ABC-21026 | Address 26 | Description 26 | Client 26 | 2021-04-26 00:00:00 | 2021-04-28 00:00:00 | 2021-04-30 00:00:00 | 001/001/026 | APPROVE
ABC-21027 | Address 27 | Description 27 | Client 27 | 2021-04-27 00:00:00 | QUOTE
ABC-21028 | Address 28 | Description 28 | Client 28 | 2021-04-28 00:00:00 | QUOTE
ABC-21029 | Address 29 | Description 29 | Client 29 | 2021-04-29 00:00:00 | QUOTE
ABC-21030 | Address 30 | Description 30 | Client 30 | 2021-04-30 00:00:00 | QUOTE
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040