Spreadsheet: 777406d1650371469-multiple-if-statements-with-countifs-on-call-example-1-
Sheet: Helper

Technician Id | Technician | Customer | Date | Job # | Dispatched | Arrived | Closed | Status | Job BU | Inv. # | Total | Payments | Pinned Notes | Hour | Date | Job Type | Estimate
61069 | Employee 3 | Customer 3 | 2022-03-14 07:58:00 | 671147912 | 2022-03-14 07:44:00 | 2022-03-14 07:58:00 | 2022-03-14 11:56:00 | Completed | Plumbing Service | 671147912 | 3672 | Credit Card-$3,672.00 | Informed customer that dispatch is going to contact tech and get an exact location on where they're at and will call back to confirm and provide further details | 7 | 2022-03-14 00:00:00 | Install | 0
664018848 | Employee 1 | Customer 1 | 2022-03-14 07:51:00 | 671090450 | 2022-03-14 07:45:00 | 2022-03-14 07:51:00 | 2022-03-14 08:44:00 | Completed | Plumbing Service | 671090450 | 69.92 | Mobile Check Capture-$69.92 | 0 | 7 | 2022-03-14 00:00:00 | Bathroom | 0
664018848 | Employee 1 | Customer 1 | 2022-03-15 08:19:00 | 671212934 | 2022-03-15 07:44:00 | 2022-03-15 08:19:00 | 2022-03-15 11:17:00 | Completed | Plumbing Service | 671212934 | 635.03 | Credit Card-$635.03 | Customer called for ETA, customer has to be some where at 6:00pm & assumed we would be there by 4:00. I let her know we work until 8:00 pm | 7 | 2022-03-15 00:00:00 | Bathroom | 635.03
61069 | Employee 3 | Customer 3 | 2022-03-17 08:01:00 | 671709420 | 2022-03-17 07:40:00 | 2022-03-17 08:01:00 | 2022-03-17 08:27:00 | Completed | Plumbing Service | 671709420 | 0 |  | 0 | 7 | 2022-03-17 00:00:00 | Gas Piping Repair | 0
27944299 | Employee 2 | Customer 2 | 2022-03-17 08:20:00 | 670727529 | 2022-03-17 07:53:00 | 2022-03-17 08:20:00 | 2022-03-17 08:56:00 | Completed | Plumbing Service | 670727529 | 0 |  | Left voicemail regarding appt today to get her back on the schedule with [NAME] and [NAME] to finish installing shower stem. Please get to Breanna, Keisha, or [NAME]. First available day for them is Tuesday 3/15/2022 | 7 | 2022-03-17 00:00:00 | Install Callback | 0
27944299 | Employee 2 | Customer 2 | 2022-03-18 08:51:00 | 671986555 | 2022-03-18 07:38:00 | 2022-03-18 08:51:00 | 2022-03-18 10:39:00 | Completed | Plumbing Service | 671986555 | 1058.49 | Credit Card-$1,058.49 | 0 | 7 | 2022-03-18 00:00:00 | Piping Leak | 1058.49
61069 | Employee 3 | Customer 3 | 2022-03-18 08:28:00 | 671992053 | 2022-03-18 07:52:00 | 2022-03-18 08:28:00 | 2022-03-18 08:36:00 | Hold | Plumbing Service | 671992053 | 2244.71 |  | NO ANSWER ON PHONE OR DOOR PLEASE GET TO DISPATCH | 7 | 2022-03-18 00:00:00 | #N/A | #N/A
27944299 | Employee 2 | Customer 2 | 2022-03-14 08:38:00 | 670791213 | 2022-03-14 08:02:00 | 2022-03-14 08:38:00 | 2022-03-14 09:27:00 | Completed | Plumbing Service | 670791213 | 0 |  | called for tech | 8 | 2022-03-14 00:00:00 | Install Callback | 0
54927019 | Employee 4 | Customer 4 | 2022-03-14 08:49:00 | 671047971 | 2022-03-14 08:02:00 | 2022-03-14 08:49:00 | 2022-03-14 09:55:00 | Completed | Plumbing Service | 671047971 | 99 | Credit Card-$99.00 | 0 | 8 | 2022-03-14 00:00:00 | Multiple Issues | 99
61069 | Employee 3 | Customer 3 | 2022-03-15 08:26:00 | 671334636 | 2022-03-15 08:05:00 | 2022-03-15 08:26:00 | 2022-03-15 17:16:00 | Completed | Plumbing Service | 671334636 | 3260.71 | [NAME] | 0 | 8 | 2022-03-15 00:00:00 | Service Callback | 0
54927019 | Employee 4 | Customer 4 | 2022-03-17 08:52:00 | 671293434 | 2022-03-17 08:01:00 | 2022-03-17 08:52:00 | 2022-03-17 09:20:00 | Completed | Plumbing Service | 671293434 | 0 |  | 0 | 8 | 2022-03-17 00:00:00 | Plumbing Inspection | 0
61069 | Employee 3 | Customer 3 | 2022-03-17 09:02:00 | 671821309 | 2022-03-17 08:28:00 | 2022-03-17 09:02:00 | 2022-03-17 09:26:00 | Completed | Plumbing Service | 671821309 | 0 |  | 0 | 8 | 2022-03-17 00:00:00 | Customer Supplied Fixture | 0
27944299 | Employee 2 | Customer 2 | 2022-03-17 09:19:00 | 671849205 | 2022-03-17 08:58:00 | 2022-03-17 09:19:00 | 2022-03-17 10:43:00 | Completed | Plumbing Service | 671849205 | 0 |  | Installing 50ga gas WH in basement. TMP line needs to be run up and out. Detailed video included. | 8 | 2022-03-17 00:00:00 | Service Callback | 1900
61069 | Employee 3 | Customer 3 | 2022-03-18 09:06:00 | 671932088 | 2022-03-18 08:45:00 | 2022-03-18 09:06:00 | 2022-03-18 09:32:00 | Completed | Plumbing Service | 671932088 | 126.78 | Mobile Check Capture-$126.78 | 0 | 8 | 2022-03-18 00:00:00 | Piping Leak | 126.78
664018848 | Employee 1 | Customer 1 | 2022-03-14 09:41:00 | 669537640 | 2022-03-14 09:22:00 | 2022-03-14 09:41:00 | 2022-03-14 10:11:00 | Completed | Plumbing Service | 669537640 | 0 |  | Left voicemail regarding appt for today, Do not have tech available to come out today but can reschedule for Thursday or later. Please get to dispatch with scheduling. | 9 | 2022-03-14 00:00:00 | Plumbing Inspection | 0
27944299 | Employee 2 | Customer 2 | 2022-03-14 10:29:00 | 670834853 | 2022-03-14 09:52:00 | 2022-03-14 10:29:00 | 2022-03-14 15:49:00 | Completed | Plumbing Service | 670834853 | 2235.57 | Credit Card-$2,235.57 | 0 | 9 | 2022-03-14 00:00:00 | [NAME] | 0
54927019 | Employee 4 | Customer 4 | 2022-03-14 10:13:00 | 670898554 | 2022-03-14 09:55:00 | 2022-03-14 10:13:00 | 2022-03-14 11:10:00 | Completed | Plumbing Service | 670898554 | 0 |  | 0 | 9 | 2022-03-14 00:00:00 | Piping Estimate | 0
54927019 | Employee 4 | Customer 4 | 2022-03-15 09:29:00 | 671283288 | 2022-03-15 09:13:00 | 2022-03-15 09:29:00 | 2022-03-15 11:34:00 | Completed | Plumbing Service | 671283288 | 700 | Credit Card-$700.00 | 0 | 9 | 2022-03-15 00:00:00 | Install | 0
27944299 | Employee 2 | Customer 2 | 2022-03-15 09:49:00 | 670970752 | 2022-03-15 09:15:00 | 2022-03-15 09:49:00 | 2022-03-15 10:30:00 | Completed | Plumbing Service | 670970752 | 0 |  | 0 | 9 | 2022-03-15 00:00:00 | Piping Leak | 0
27944299 | Employee 2 | Customer 2 | 2022-03-16 10:10:00 | 671539612 | 2022-03-16 09:30:00 | 2022-03-16 10:10:00 | 2022-03-16 13:30:00 | Completed | Plumbing Service | 671539612 | 2301.42 | Credit Card-$2,301.42 | 0 | 9 | 2022-03-16 00:00:00 | [NAME] | 0
61069 | Employee 3 | Customer 3 | 2022-03-16 10:07:00 | 671495018 | 2022-03-16 09:43:00 | 2022-03-16 10:07:00 | 2022-03-16 11:47:00 | Completed | Plumbing Service | 671495018 | 0 |  | 0 | 9 | 2022-03-16 00:00:00 | Piping Estimate | 3793.55
54927019 | Employee 4 | Customer 4 | 2022-03-17 10:09:00 | 671282418 | 2022-03-17 09:38:00 | 2022-03-17 10:09:00 | 2022-03-17 10:56:00 | Completed | Plumbing Service | 671282418 | 0 |  | 0 | 9 | 2022-03-17 00:00:00 | Plumbing Inspection | 0
61069 | Employee 3 | Customer 3 | 2022-03-17 10:05:00 | 671881449 | 2022-03-17 09:39:00 | 2022-03-17 10:05:00 | 2022-03-17 10:44:00 | Completed | Plumbing Service | 671881449 | 198 | Credit Card-$198.00 | 0 | 9 | 2022-03-17 00:00:00 | Bathroom | 198
664018848 | Employee 1 | Customer 1 | 2022-03-18 09:52:00 | 671765744 | 2022-03-18 09:15:00 | 2022-03-18 09:52:00 | 2022-03-18 10:38:00 | Completed | Plumbing Service | 671765744 | 0 |  | 0 | 9 | 2022-03-18 00:00:00 | Plumbing Inspection | 0
61069 | Employee 3 | Customer 3 | 2022-03-18 10:18:00 | 671097034 | 2022-03-18 09:41:00 | 2022-03-18 10:18:00 | 2022-03-18 11:24:00 | Completed | Plumbing Service | 671097034 | 0 |  | 0 | 9 | 2022-03-18 00:00:00 | Plumbing Inspection | 0
664018848 | Employee 1 | Customer 1 | 2022-03-14 10:59:00 | 671095399 | 2022-03-14 10:49:00 | 2022-03-14 10:59:00 | 2022-03-14 11:32:00 | Completed | Plumbing Service | 671095399 | 0 |  | 0 | 10 | 2022-03-14 00:00:00 | Toilet Repair/Replace | 0
27944299 | Employee 2 | Customer 2 | 2022-03-15 11:04:00 | 671215269 | 2022-03-15 10:38:00 | 2022-03-15 11:04:00 | 2022-03-15 11:18:00 | Completed | Plumbing Service | 671215269 | 0 |  | 0 | 10 | 2022-03-15 00:00:00 | Service Callback | 0
54927019 | Employee 4 | Customer 4 | 2022-03-16 10:05:00 | 671542250 | 2022-03-16 10:00:00 | 2022-03-16 10:05:00 | 2022-03-16 18:38:00 | Completed | Plumbing Service | 671542250 | 1580.04 | Credit Card-$1,580.04 | 0 | 10 | 2022-03-16 00:00:00 | Plumbing Inspection | 0
61069 | Employee 3 | Customer 3 | 2022-03-17 11:07:00 | 671884537 | 2022-03-17 10:47:00 | 2022-03-17 11:07:00 | 2022-03-17 11:53:00 | Completed | Plumbing Service | 671884537 | 447.24 | Credit Card-$447.24 | 0 | 10 | 2022-03-17 00:00:00 | Piping Leak | 447.24
27944299 | Employee 2 | Customer 2 | 2022-03-18 11:45:00 | 672083439 | 2022-03-18 10:41:00 | 2022-03-18 11:45:00 | 2022-03-18 12:53:00 | Completed | Plumbing Service | 672083439 | 438.14 | Mobile Check Capture-$438.14 | 0 | 10 | 2022-03-18 00:00:00 | Kitchen | 438.14
61069 | Employee 3 | Customer 3 | 2022-03-19 11:07:00 | 672113457 | 2022-03-19 10:49:00 | 2022-03-19 11:07:00 | 2022-03-19 12:41:00 | Completed | Plumbing Service | 672113457 | 1897 | Credit Card-$1,897.00 | 0 | 10 | 2022-03-19 00:00:00 | [NAME] | 0
54927019 | Employee 4 | Customer 4 | 2022-03-14 11:24:00 | 671218419 | 2022-03-14 11:10:00 | 2022-03-14 11:24:00 | 2022-03-14 14:45:00 | Completed | Plumbing Service | 671218419 | 590 | Credit Card-$198.00; Credit Card-$392.00 | 0 | 11 | 2022-03-14 00:00:00 | Pump | 590
664018848 | Employee 1 | Customer 1 | 2022-03-14 11:41:00 | 671220607 | 2022-03-14 11:41:00 | 2022-03-14 11:41:00 | 2022-03-14 12:43:00 | Completed | Plumbing Service | 671220607 | 200.36 | Credit Card-$200.36 | 0 | 11 | 2022-03-14 00:00:00 | Bathroom | 200.36
27944299 | Employee 2 | Customer 2 | 2022-03-15 11:34:00 | 671277096 | 2022-03-15 11:27:00 | 2022-03-15 11:34:00 | 2022-03-15 12:02:00 | Completed | Plumbing Service | 671277096 | 0 |  | Called in for ETA | 11 | 2022-03-15 00:00:00 | Piping Leak | 0
664018848 | Employee 1 | Customer 1 | 2022-03-15 11:38:00 | 669895761 | 2022-03-15 11:38:00 | 2022-03-15 11:38:00 | 2022-03-15 12:13:00 | Completed | Plumbing Service | 669895761 | 0 |  | Need to meet with the gas company for a site survey have flexible gas lines running through the house to the new pool and hot tub area . Customer wants pipes rerouted into basement from the new gas meter the gas company will install. Gas company requested to meet for a site survey with technician who will be doing the gas line | 11 | 2022-03-15 00:00:00 | Piping Estimate | 0
61069 | Employee 3 | Customer 3 | 2022-03-16 12:02:00 | 671659625 | 2022-03-16 11:49:00 | 2022-03-16 12:02:00 | 2022-03-16 12:17:00 | Completed | Plumbing Service | 671659625 | 162.68 | Credit Card-$162.68 | 0 | 11 | 2022-03-16 00:00:00 | [NAME] | 162.68
27944299 | Employee 2 | Customer 2 | 2022-03-17 12:13:00 | 671846389 | 2022-03-17 11:43:00 | 2022-03-17 12:13:00 | 2022-03-17 12:37:00 | Completed | Plumbing Service | 671846389 | 0 |  | 0 | 11 | 2022-03-17 00:00:00 | [NAME] | 0
61069 | Employee 3 | Customer 3 | 2022-03-17 12:09:00 | 671864612 | 2022-03-17 11:56:00 | 2022-03-17 12:09:00 | 2022-03-17 13:29:00 | Completed | Plumbing Service | 671864612 | 287 | Credit Card-$287.00 | 0 | 11 | 2022-03-17 00:00:00 | Drain Plus | 287
664018848 | Employee 1 | Customer 1 | 2022-03-18 12:12:00 | 670642492 | 2022-03-18 11:00:00 | 2022-03-18 12:12:00 | 2022-03-18 13:58:00 | Completed | Plumbing Service | 670642492 | 777.23 | Credit Card-$777.23 | 0 | 11 | 2022-03-18 00:00:00 | Plumbing Inspection | 777.23
61069 | Employee 3 | Customer 3 | 2022-03-18 11:41:00 | 672085491 | 2022-03-18 11:25:00 | 2022-03-18 11:41:00 | 2022-03-18 12:00:00 | Completed | Plumbing Service | 672085491 | 0 |  | 0 | 11 | 2022-03-18 00:00:00 | Piping Leak | 0
54927019 | Employee 4 | Customer 4 | 2022-03-15 13:40:00 | 671297169 | 2022-03-15 12:15:00 | 2022-03-15 13:40:00 | 2022-03-15 14:48:00 | Completed | Plumbing Service | 671297169 | 338 | Credit Card-$338.00 | 0 | 12 | 2022-03-15 00:00:00 | Plumbing Inspection | 1918.04
27944299 | Employee 2 | Customer 2 | 2022-03-15 12:57:00 | 671121313 | 2022-03-15 12:40:00 | 2022-03-15 12:57:00 | 2022-03-15 13:16:00 | Completed | Plumbing Service | 671121313 | 0 |  | 0 | 12 | 2022-03-15 00:00:00 | Piping Leak | 0
664018848 | Employee 1 | Customer 1 | 2022-03-15 12:43:00 | 667610729 | 2022-03-15 12:43:00 | 2022-03-15 12:43:00 | 2022-03-15 13:10:00 | Completed | Plumbing Service | 667610729 | 0 |  | 0 | 12 | 2022-03-15 00:00:00 | Plumbing Inspection | 0
61069 | Employee 3 | Customer 3 | 2022-03-16 12:59:00 | 671542002 | 2022-03-16 12:34:00 | 2022-03-16 12:59:00 | 2022-03-16 13:23:00 | Completed | Plumbing Service | 671542002 | 0 |  | 0 | 12 | 2022-03-16 00:00:00 | Water Treatment | 0
54927019 | Employee 4 | Customer 4 | 2022-03-17 13:07:00 | 671893366 | 2022-03-17 12:43:00 | 2022-03-17 13:07:00 | 2022-03-17 18:00:00 | Completed | Plumbing Service | 671893366 | 1000 |  | I spoke to the customer and let him know the issue wasn't with the water heater but the recirculating pump. The estimate was for a new recirculating pump. He would like for us to come back out and get the work done. Talked to izabella to get this scheduled back on Brad.<br />transfer to [NAME] | 12 | 2022-03-17 00:00:00 | Service Callback | 1000
664018848 | Employee 1 | Customer 1 | 2022-03-14 14:16:00 | 671278338 | 2022-03-14 13:19:00 | 2022-03-14 14:16:00 | 2022-03-14 15:06:00 | Completed | Plumbing Service | 671278338 | 0 |  | 0 | 13 | 2022-03-14 00:00:00 | Piping Leak | 0
61069 | Employee 3 | Customer 3 | 2022-03-14 13:50:00 | 671097146 | 2022-03-14 13:26:00 | 2022-03-14 13:50:00 | 2022-03-14 15:03:00 | Completed | Plumbing Service | 671097146 | 0 |  | 0 | 13 | 2022-03-14 00:00:00 | Service Callback | 3260.71
27944299 | Employee 2 | Customer 2 | 2022-03-15 13:46:00 | 670651973 | 2022-03-15 13:17:00 | 2022-03-15 13:46:00 | 2022-03-15 15:02:00 | Completed | Plumbing Service | 670651973 | 69 | Cash-$69.00 | 0 | 13 | 2022-03-15 00:00:00 | Pump | 0
664018848 | Employee 1 | Customer 1 | 2022-03-15 14:42:00 | 671146529 | 2022-03-15 13:46:00 | 2022-03-15 14:42:00 | 2022-03-15 18:38:00 | Completed | Plumbing Service | 671146529 | 1412.68 | Mobile Check Capture-$1,412.68 | 0 | 13 | 2022-03-15 00:00:00 | Kitchen | 1412.68
27944299 | Employee 2 | Customer 2 | 2022-03-17 13:14:00 | 671915013 | 2022-03-17 13:10:00 | 2022-03-17 13:14:00 | 2022-03-17 14:06:00 | Completed | Plumbing Service | 671915013 | 0 |  | Complete basement repipe(cast iron). Two toilets, two Lav branch line, Ksink line and laundry tub/washer right beside stack. Install clean out tee at bottom of stack. Detailed video included. | 13 | 2022-03-17 00:00:00 | Multiple Issues | 6500
61069 | Employee 3 | Customer 3 | 2022-03-17 13:54:00 | 671798126 | 2022-03-17 13:39:00 | 2022-03-17 13:54:00 | 2022-03-17 14:00:00 | Completed | Plumbing Service | 671798126 | 0 |  | 0 | 13 | 2022-03-17 00:00:00 | Piping Leak | 0
27944299 | Employee 2 | Customer 2 | 2022-03-18 14:18:00 | 672127223 | 2022-03-18 13:30:00 | 2022-03-18 14:18:00 | 2022-03-18 14:20:00 | Completed | Plumbing Service | 672127223 | 0 |  | 0 | 13 | 2022-03-18 00:00:00 | Service Callback | 0
54927019 | Employee 4 | Customer 4 | 2022-03-15 15:30:00 | 670682740 | 2022-03-15 14:50:00 | 2022-03-15 15:30:00 | 2022-03-15 16:29:00 | Completed | Plumbing Service | 670682740 | 0 |  | called to say he's home and ready | 14 | 2022-03-15 00:00:00 | Multiple Issues | 1984.86
27944299 | Employee 2 | Customer 2 | 2022-03-16 14:46:00 | 671283218 | 2022-03-16 14:18:00 | 2022-03-16 14:46:00 | 2022-03-16 16:54:00 | Completed | Plumbing Service | 671283218 | 724.42 | Credit Card-$724.42 | 0 | 14 | 2022-03-16 00:00:00 | Bathroom | 724.42
61069 | Employee 3 | Customer 3 | 2022-03-16 15:32:00 | 671706017 | 2022-03-16 14:55:00 | 2022-03-16 15:32:00 | 2022-03-16 17:02:00 | Completed | Plumbing Service | 671706017 | 563.93 | Credit Card-$563.93 | 0 | 14 | 2022-03-16 00:00:00 | Service Callback | 563.93
27944299 | Employee 2 | Customer 2 | 2022-03-17 14:45:00 | 671949167 | 2022-03-17 14:07:00 | 2022-03-17 14:45:00 | 2022-03-17 15:11:00 | Completed | Plumbing Service | 671949167 | 0 |  | 0 | 14 | 2022-03-17 00:00:00 | Piping Leak | 0
61069 | Employee 3 | Customer 3 | 2022-03-17 14:54:00 | 671939564 | 2022-03-17 14:30:00 | 2022-03-17 14:54:00 | 2022-03-17 16:08:00 | Completed | Plumbing Service | 671939564 | 0 |  | 0 | 14 | 2022-03-17 00:00:00 | Customer Supplied Fixture | 2244.71
61069 | Employee 3 | Customer 3 | 2022-03-18 14:19:00 | 672126190 | 2022-03-18 14:00:00 | 2022-03-18 14:19:00 | 2022-03-18 14:49:00 | Completed | Plumbing Service | 672126190 | 0 |  | 0 | 14 | 2022-03-18 00:00:00 | Piping Estimate | 0
61069 | Employee 3 | Customer 3 | 2022-03-18 15:16:00 | 672125169 | 2022-03-18 14:52:00 | 2022-03-18 15:16:00 | 2022-03-18 16:10:00 | Completed | Plumbing Service | 672125169 | 0 |  | 0 | 14 | 2022-03-18 00:00:00 | [NAME] | 1897
61069 | Employee 3 | Customer 3 | 2022-03-14 15:42:00 | 671253867 | 2022-03-14 15:09:00 | 2022-03-14 15:42:00 | 2022-03-14 16:30:00 | Completed | Plumbing Service | 671253867 | 556.99 | Credit Card-$556.99 | called for update | 15 | 2022-03-14 00:00:00 | Bathroom | 556.99
664018848 | Employee 1 | Customer 1 | 2022-03-14 15:44:00 | 671285261 | 2022-03-14 15:20:00 | 2022-03-14 15:44:00 | 2022-03-14 16:54:00 | Completed | Plumbing Service | 671285261 | 318.58 | Credit Card-$318.58 | 0 | 15 | 2022-03-14 00:00:00 | [NAME] | 318.58
54927019 | Employee 4 | Customer 4 | 2022-03-14 15:49:00 | 671285242 | 2022-03-14 15:29:00 | 2022-03-14 15:49:00 | 2022-03-14 16:36:00 | Completed | Plumbing Service | 671285242 | 231.92 | Credit Card-$231.92 | 0 | 15 | 2022-03-14 00:00:00 | Toilet Repair/Replace | 231.92
27944299 | Employee 2 | Customer 2 | 2022-03-15 15:38:00 | 671455915 | 2022-03-15 15:04:00 | 2022-03-15 15:38:00 | 2022-03-15 16:26:00 | Completed | Plumbing Service | 671455915 | 0 |  | 0 | 15 | 2022-03-15 00:00:00 | [NAME] | 2301.42
27944299 | Employee 2 | Customer 2 | 2022-03-17 15:27:00 | 671151770 | 2022-03-17 15:15:00 | 2022-03-17 15:27:00 | 2022-03-17 17:01:00 | Completed | Plumbing Service | 671151770 | 0 |  | call for tech<br />CUSTOMER NEEDED TO RESCHEDULE, MOVED TO 3/17/22 | 15 | 2022-03-17 00:00:00 | Piping Estimate | 8000
664018848 | Employee 1 | Customer 1 | 2022-03-18 15:35:00 | 672119729 | 2022-03-18 15:23:00 | 2022-03-18 15:35:00 | 2022-03-18 17:08:00 | Completed | Plumbing Service | 672119729 | 1451 | Credit Card-$1,451.00 | 0 | 15 | 2022-03-18 00:00:00 | [NAME] | 1451
54927019 | Employee 4 | Customer 4 | 2022-03-14 17:08:00 | 671281260 | 2022-03-14 16:36:00 | 2022-03-14 17:08:00 | 2022-03-14 17:16:00 | Completed | Plumbing Service | 671281260 | 0 |  | Tried calling [NAME] all day and tenant as well. If landlord calls back we just need to know if she knew that tenant had called us regarding their water heater, because we were out there on 3/4/2022 and gave estimates on the water heater and the landlord said that our prices were too high and she is going with another company. So I did not know if she was aware of the appointment made for today 3/15/2022. If tenant calls back we just need to ask him if the landlord is aware of this appointment since she did say she was going with another company, and let him know if she is aware then she needs to call us and let us know or if she wants to go with one of estimates given on 3/4/2022. Or if we just need to cancel this appointment. | 16 | 2022-03-14 00:00:00 | [NAME] | 0
27944299 | Employee 2 | Customer 2 | 2022-03-15 16:31:00 | 671535868 | 2022-03-15 16:26:00 | 2022-03-15 16:31:00 | 2022-03-15 17:22:00 | Completed | Plumbing Service | 671535868 | 0 |  | Whole house gas repipe(crawlspace). Will be servicing 3utilities. WH, furnace and dryer. Also running line for gas stove for potential use. Currently has electric stove. Detailed video included. | 16 | 2022-03-15 00:00:00 | Gas Piping Repair | 3750
54927019 | Employee 4 | Customer 4 | 2022-03-15 17:02:00 | 671346308 | 2022-03-15 16:31:00 | 2022-03-15 17:02:00 | 2022-03-15 17:45:00 | Completed | Plumbing Service | 671346308 | 198 | Mobile Check Capture-$198.00 | Update 1 Could not get a hold of Sondra Flowers: For BASIC Update Call * Requesting After 3 pm (Left VM and Sent Text) - Added Update Tag | 16 | 2022-03-15 00:00:00 | Bathroom | 198
61069 | Employee 3 | Customer 3 | 2022-03-17 16:32:00 | 671984617 | 2022-03-17 16:09:00 | 2022-03-17 16:32:00 | 2022-03-17 17:16:00 | Completed | Plumbing Service | 671984617 | 162.68 | [NAME] Capture-$162.68 | 0 | 16 | 2022-03-17 00:00:00 | [NAME] | 162.68
54927019 | Employee 4 | Customer 4 | 2022-03-14 18:21:00 | 670346781 | 2022-03-14 17:18:00 | 2022-03-14 18:21:00 | 2022-03-14 18:35:00 | Completed | Plumbing Service | 670346781 | 0 |  | 0 | 17 | 2022-03-14 00:00:00 | Piping Estimate | 0
54927019 | Employee 4 | Customer 4 | 2022-03-15 17:59:00 | 671325831 | 2022-03-15 17:48:00 | 2022-03-15 17:59:00 | 2022-03-15 18:42:00 | Completed | Plumbing Service | 671325831 | 0 |  | Update 1 Could not get a hold of [NAME] berry: For BASIC Update Call (Left VM and Sent Text) - Added Update Tag | 17 | 2022-03-15 00:00:00 | [NAME] | 0
27944299 | Employee 2 | Customer 2 | 2022-03-17 17:19:00 | 671969769 | 2022-03-17 17:02:00 | 2022-03-17 17:19:00 | 2022-03-17 17:45:00 | Completed | Plumbing Service | 671969769 | 0 |  | 0 | 17 | 2022-03-17 00:00:00 | Service Callback | 0
54927019 | Employee 4 | Customer 4 | 2022-03-17 18:41:00 | 671636514 | 2022-03-17 18:07:00 | 2022-03-17 18:41:00 | 2022-03-17 19:04:00 | Completed | Plumbing Service | 671636514 | 175 |  | 0 | 20 | 2022-03-17 00:00:00 | Piping Estimate | 1300
54927019 | Employee 4 | Customer 4 | 2022-03-17 18:41:00 | 671636514 | 2022-03-17 18:07:00 | 2022-03-17 18:41:00 | 2022-03-17 19:04:00 | Completed | Plumbing Service | 671636514 | 150 |  | 0 | 20 | 2022-03-17 00:00:00 | Service Callback | 1000
27944299 | Employee 2 | Customer 2 | 2022-03-17 17:19:00 | 671969769 | 2022-03-17 17:02:00 | 2022-03-17 17:19:00 | 2022-03-17 17:45:00 | Completed | Plumbing Service | 671969769 | 0 |  | 0 | 20 | 2022-03-17 00:00:00 | Service Callback | 0
27944299 | Employee 2 | Customer 2 | 2022-03-17 17:19:00 | 671969769 | 2022-03-17 17:02:00 | 2022-03-17 17:19:00 | 2022-03-17 17:45:00 | Completed | Plumbing Service | 671969769 | 125 |  | 0 | 12 | 2022-03-17 00:00:00 | Service Callback | 800
27944299 | Employee 2 | Customer 2 | 2022-03-17 17:19:00 | 671969769 | 2022-03-17 17:02:00 | 2022-03-17 17:19:00 | 2022-03-17 17:45:00 | Completed | Plumbing Service | 671969769 | 0 |  | 0 | 20 | 2022-03-17 00:00:00 | Piping Estimate | 0
27944299 | Employee 2 | Customer 2 | 2022-03-17 17:19:00 | 671969769 | 2022-03-17 17:02:00 | 2022-03-17 17:19:00 | 2022-03-17 17:45:00 | Completed | Plumbing Service | 671969769 | 345 |  | 0 | 20 | 2022-03-17 00:00:00 | Piping Estimate | 0