Spreadsheet: 734462d1622183571-nested-if-error-demo
Sheet: CMS Time Tickets

Ticket Type | (All)
Tickets |  | LEM Number | Ticket Date | Date Received | To Be Entered |  | Date | Ticket # | Job #
001425 |  | 001425 | 2021-05-23 00:00:00 | 2021-05-26 00:00:00 |  |  | 2021-05-25 00:00:00 | 001439 | 21078
001426 |  | 001426 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 |  |  | 2021-05-26 00:00:00 | 001446 | 21078
001438 |  | 001438 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 |  |  | 2021-05-25 00:00:00 | 001436 | 21057
11111-13-49 |  | 001436 | 2021-05-25 00:00:00 | 2021-05-27 00:00:00 |  |  | 2021-05-26 00:00:00 | 001442 | 21057
11111-13-50 |  | 001442 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 |  |  | 2021-05-25 00:00:00 | 001435 | 21081
21031-26-155 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
21031-26-156 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
21031-26-157 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
21031-26-158 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
21031-26-159 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
21031-26-160 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
21060-26-21 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
Manual Timesheet |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
Grand Total |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-23 00:00:00 | 001430 | 21074
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001437 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001446 | 21078
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001437 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-23 00:00:00 | 001425 | 20099
 |  |  |  |  |  |  | 2021-05-24 00:00:00 | 001426 | 20099
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-23 00:00:00 | 001425 | 20099
 |  |  |  |  |  |  | 2021-05-24 00:00:00 | 001426 | 20099
 |  |  |  |  |  |  | 2021-05-23 00:00:00 | 001425 | 20099
 |  |  |  |  |  |  | 2021-05-24 00:00:00 | 001426 | 20099
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001439 | 21078
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001446 | 21078
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001436 | 21057
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001442 | 21057
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001438 | 21065
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001444 | 21065
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-26 00:00:00 | 001445 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-25 00:00:00 | 001435 | 21081
 |  |  |  |  |  |  | 2021-05-23 00:00:00 | 001425 | 20099
 |  |  |  |  |  |  | 2021-05-24 00:00:00 | 001426 | 20099