Spreadsheet: 846968d1698090739-nested-if-function-to-find-3rd-criteria-demo
Sheet: Consolidated Time

Ticket Copy/Paste
Date | Ticket # | Job # | EE Type | Pay Type | Resource | CC | RT | TT | LOA | Truck | Office Trailer | Project Manager | OT | DT | LOA Helper | [NAME] | Employee Status | Total Daily Hours | Hours Confirmed | Investigate | Reason | [NAME] | PM Count | Required Formula Answer |  | Column X is the formula I'm working on, Column Y is the result I want
2023-10-10 00:00:00 | 017222 | 23210 | Employee | HR | DALWHI | 2.1.1 | 10.5 |  |  |  |  | PM3
2023-10-11 00:00:00 | 017275 | 23210 | Employee | HR | DALWHI | 2.1.1 | 9.5 |  |  |  |  | PM3
2023-10-12 00:00:00 | 017308 | 23210 | Employee | HR | DALWHI | 2.1.1 | 9.5 |  |  |  |  | PM3
2023-10-13 00:00:00 | 017354 | 23210 | Employee | HR | DALWHI | 2.1.1 | 8 |  |  |  |  | PM3
2023-10-10 00:00:00 | 017233 | 23137 | Contractor | HR | ANNENT | 2.5 | 12 |  |  |  |  | PM1
2023-10-11 00:00:00 | 017267 | 23137 | Contractor | HR | ANNENT | 2.5 | 12 |  |  |  |  | PM1
2023-10-12 00:00:00 | 017309 | 23137 | Contractor | HR | ANNENT | 2.5 | 10 |  |  |  |  | PM1 |  |  |  |  |  |  |  |  |  |  |  | True
2023-10-12 00:00:00 | 017299 | 23177 | Contractor | HR | ANNENT | 4.2 | 3 |  |  |  |  | PM2 |  |  |  |  |  |  | Partially Confirmed |  |  |  |  | True
2023-10-13 00:00:00 | 017312 | 23177 | Contractor | HR | ANNENT | 4.2 | 13 |  |  |  |  | PM2 |  |  |  |  |  |  | Confirmed
2023-10-14 00:00:00 | 017340 | 23177 | Contractor | HR | ANNENT | 4.2 | 12 |  |  |  |  | PM2
2023-10-10 00:00:00 | 017233 | 23137 | Contractor | HR | ANNENT | 2.5 |  |  | 185 |  |  | PM1
2023-10-11 00:00:00 | 017267 | 23137 | Contractor | HR | ANNENT | 2.5 |  |  | 185 |  |  | PM1
2023-10-12 00:00:00 | 017299 | 23177 | Contractor | HR | ANNENT | 4.2 |  |  | 175 |  |  | PM2
2023-10-13 00:00:00 | 017312 | 23177 | Contractor | HR | ANNENT | 4.2 |  |  | 175 |  |  | PM2
2023-10-14 00:00:00 | 017340 | 23177 | Contractor | HR | ANNENT | 4.2 |  |  | 175 |  |  | PM2
2023-10-16 00:00:00 | 017456 | 23205 | Employee | HR | DALWHI | 4.9 | 3.5 |  |  |  |  | PM1 |  |  |  |  |  |  |  |  |  |  |  | True
2023-10-16 00:00:00 | 017383 | 23210 | Employee | HR | DALWHI | 2.1.1 | 3.5 |  |  |  |  | PM3 |  |  |  |  |  |  |  |  |  |  |  | True
2023-10-16 00:00:00 | 017387 | 23152 | Employee | HR | DALWHI | 3.1 | 8 |  |  |  |  | PM2 |  |  |  |  |  |  |  |  |  |  |  | True
2023-10-17 00:00:00 | 017463 | 23153 | Employee | HR | DALWHI | 4.1 | 6.5 |  |  |  |  | PM2 |  |  |  |  |  |  |  |  |  |  |  | False
2023-10-17 00:00:00 | 017512 | 23152 | Employee | HR | DALWHI | 3.1 | 11.5 |  |  |  |  | PM2 |  |  |  |  |  |  |  |  |  |  |  | False
2023-10-15 00:00:00 | 017347 | 23137 | Contractor | HR | ANNENT | 2.5 | 3 |  |  |  |  | PM1
2023-10-15 00:00:00 | 017341 | 23177 | Contractor | HR | ANNENT | 4.2 | 7 |  |  |  |  | PM2
2023-10-16 00:00:00 | 017421 | 23201 | Contractor | HR | ANNENT | 2.5 | 3 |  |  |  |  | PM1
2023-10-16 00:00:00 | 017374 | 23137 | Contractor | HR | ANNENT | 2.5 | 8 |  |  |  |  | PM1
2023-10-15 00:00:00 | 017347 | 23137 | Contractor | HR | ANNENT | 2.5 |  |  | 185 |  |  | PM1
2023-10-16 00:00:00 | 017421 | 23201 | Contractor | HR | ANNENT | 2.5 |  |  | 175 |  |  | PM1
Should = FALSE as there is on;y one PM
Should Equal TRUE as there is more than one PM