Spreadsheet: 752285d1634687655-problem-with-nested-if-formula-september-rankings
Sheet: Metrics

 | Manager | Position | Agent | Completed Authorizations | Completed Welcome Calls | Courtesy Calls | Redrafts | Global Validation Units | [NAME] (2+ Mins) | Retainers / AM Saves | Acct Adds/Re-Adds | Positive Actions | Handled (Inbound) | Handled (Outbound) | Contacts Handled | ADP Hours | [NAME] | Positive Actions/HR | Contacts/HR | Available Hours | Inbound Hours | Outbound Hours (excl. OB Email) | Consult Hours | Hours in Meetings | Working Hours (w/ OB Email) | Working Hours (excl. OB Email) | Working Rate (ADP) | Contact Efficiency
 | Enos | Customer Service | [NAME] | 26 | 5 | 26 | 50 | 5 | 0 | 0 |  | 112 | 973 | 1437 | 2410 | 137.1 | 154.7 | 0.8 | 17.6 | 17.9 | 47.8 | 25 | 0.5 | 2.2 | 93.2 | 0.68 | 0.68
 | Enos | Customer Service | [NAME] | 51 | 13 | 58 | 58 | 1 | 0 | 13 | 11 | 194 | 638 | 1072 | 1710 | 167 | 182.3 | 1.2 | 10.2 | 14.2 | 64.4 | 25.2 | 0.3 | 3.3 | 107.5 | 0.644 | 0.644
 | Enos | Customer Service | [NAME] | 57 | 12 | 69 | 31 | 20 | 0 | 0 |  | 189 | 574 | 1301 | 1875 | 160.8 | 174.6 | 1.2 | 11.7 | 11.1 | 59.1 | 38.1 | 1.1 | 1.7 | 111.1 | 0.691 | 0.691
 | Enos | Customer Service | [NAME] | 24 | 0 | 25 | 25 | 9 | 0 | 2 | 8 | 85 | 509 | 718 | 1227 | 140.3 | 152.8 | 0.6 | 8.7 | 12.3 | 44.6 | 15.2 | 0.4 | 3.5 | 76.1 | 0.542 | 0.542
 | Enos | Customer Service | [NAME] | 75 | 11 | 59 | 69 | 7 | 0 | 9 | 1 | 230 | 722 | 1301 | 2023 | 161 | 179.9 | 1.4 | 12.6 | 12.8 | 58.1 | 42.8 | 0.3 | 1.7 | 115.7 | 0.718 | 0.718
 | Enos | Customer Service | [NAME] | 55 | 0 | 34 | 43 | 0 | 0 | 3 | 3 | 135 | 628 | 831 | 1459 | 158.1 | 171.9 | 0.9 | 9.2 | 15.9 | 64.5 | 26.2 | 3 | 5 | 114.6 | 0.725 | 0.725
 | Enos | Customer Service | [NAME] | 85 | 4 | 74 | 39 | 24 | 0 | 13 | 3 | 239 | 558 | 1317 | 1875 | 159.1 | 171.3 | 1.5 | 11.8 | 10.8 | 59.2 | 30.3 | 0.6 | 6.2 | 107 | 0.672 | 0.672
 | Enos | Customer Service | Tiffany McManus | 35 | 6 | 24 | 25 | 2 | 0 | 7 | 0 | 99 | 1123 | 2018 | 3141 | 130.8 | 143.6 | 0.8 | 24 | 16.6 | 41.3 | 13.8 | 1 | 0.7 | 73.4 | 0.561 | 0.561
 | Enos | Customer Service | [NAME] | 82 | 13 | 51 | 108 | 8 | 0 | 12 | 3 | 274 | 387 | 975 | 1362 | 170.8 | 184.2 | 1.6 | 8 | 9.3 | 56.3 | 46 | 0.4 | 2.4 | 114.5 | 0.67 | 0.67
 | Norton | Customer Service | Amelia [NAME] | 45 | 11 | 61 | 61 | 6 | 0 | 10 | 0 | 194 | 504 | 1061 | 1565 | 143.8 | 156.2 | 1.3 | 10.9 | 17.5 | 61.3 | 32.6 | 0.4 | 1.9 | 113.7 | 0.791 | 0.791
 | Norton | Customer Service | [NAME] | 35 | 9 | 44 | 41 | 11 | 0 | 8 |  | 148 | 428 | 868 | 1296 | 128.6 | 140.3 | 1.2 | 10.1 | 18.6 | 46 | 26.9 | 0.7 | 1.1 | 93.2 | 0.725 | 0.725
 | Norton | Customer Service | [NAME] | 60 | 6 | 26 | 22 | 0 | 0 | 6 | 3 | 120 | 770 | 1341 | 2111 | 151.5 | 165.4 | 0.8 | 13.9 | 24.3 | 49.7 | 35.7 | 1.7 | 3 | 114.3 | 0.755 | 0.755
 | Norton | Customer Service | [NAME] | 35 | 7 | 35 | 44 | 1 | 0 | 5 | 4 | 127 | 277 | 563 | 840 | 91.6 | 99.3 | 1.4 | 9.2 | 10.6 | 27.8 | 15.9 | 0.2 | 1.6 | 56.1 | 0.612 | 0.612
 | Norton | Customer Service | [NAME] | 44 | 4 | 46 | 38 | 17 | 0 | 9 | 2 | 158 | 506 | 982 | 1488 | 156.2 | 171.3 | 1 | 9.5 | 18.8 | 49.1 | 25.9 | 0.4 | 1.2 | 95.3 | 0.61 | 0.61
 | Norton | Customer Service | [NAME] | 28 | 8 | 29 | 0 | 7 | 0 | 7 | 4 | 79 | 343 | 441 | 784 | 121.1 | 133.1 | 0.7 | 6.5 | 11.6 | 45 | 26.4 | 0.3 | 0.6 | 83.8 | 0.692 | 0.692
 | Norton | Customer Service | [NAME] | 27 | 19 | 33 | 52 | 17 | 0 | 16 | 9 | 164 | 454 | 871 | 1325 | 146.5 | 160.1 | 1.1 | 9 | 15.8 | 64.1 | 34 | 0.6 | 2.9 | 117.4 | 0.802 | 0.802
 | Pigott |  | [NAME] | 36 | 21 | 25 | 28 | 11 | 0 | 0 | 0 | 121 | 851 |  | 851 | 134.8 |  | 0.9 | 6.3 |  |  |  |  |  |  |  | 0.674
 | Pigott |  | [NAME] | 49 | 24 | 18 | 41 | 16 | 0 | 0 | 9 | 157 | 1354 |  | 1354 | 171.2 |  | 0.9 | 7.9 |  |  |  |  |  |  |  | 0.764
 | Pigott |  | [NAME] | 16 | 17 | 28 | 18 | 15 | 0 | 0 | 0 | 94 | 1023 |  | 1023 | 157.4 |  | 0.6 | 6.5 |  |  |  |  |  |  |  | 0.771
 | Pigott |  | Ines Beltran | 14 | 10 | 21 | 19 | 6 | 111 | 1 | 4 | 131 | 696 |  | 696 | 128.4 |  | 1 | 5.4 |  |  |  |  |  |  |  | 0.68
 | Pigott |  | [NAME] | 16 | 5 | 14 | 33 | 11 | 0 | 1 | 11 | 195 | 767 |  | 767 | 145.7 |  | 1.3 | 5.3 |  |  |  |  |  |  |  | 0.762
 | Pigott |  | [NAME] | 55 | 21 | 24 | 23 | 22 | 109 | 0 | 0 | 200 | 1265 |  | 1265 | 151.8 |  | 1.3 | 8.3 |  |  |  |  |  |  |  | 0.818
 | Pigott |  | [NAME] | 30 | 16 | 16 | 17 | 9 | 0 | 0 | 10 | 98 | 887 |  | 887 | 145.2 |  | 0.7 | 6.1 |  |  |  |  |  |  |  | 0.829
 | Pigott |  | Paola Saldivar-Guzman | 38 | 20 | 24 | 33 | 12 | 100 | 0 | 0 | 177 | 1007 |  | 1007 | 169.8 |  | 1 | 5.9 |  |  |  |  |  |  |  | 0.674
 | Pigott |  | [NAME] | 28 | 29 | 24 | 7 | 9 | 0 | 0 | 0 | 97 | 984 |  | 984 | 127.3 |  | 0.8 | 7.7 |  |  |  |  |  |  |  | 0.741
 | Pigott |  | [NAME] | 37 | 17 | 33 | 43 | 15 | 0 | 0 | 0 | 145 | 1101 |  | 1101 | 139.5 |  | 1 | 7.9 |  |  |  |  |  |  |  | 0.859
 | Porter | Customer Service | [NAME] | 50 | 14 | 26 | 30 | 11 | 0 | 13 |  | 144 | 396 | 461 | 857 | 160.6 | 176.3 | 0.9 | 5.3 | 17.2 | 79.5 | 28.2 | 0.3 | 11.7 | 136.9 | 0.852 | 0.852
 | Porter | Customer Service | April Cleveland | 47 | 4 | 33 | 38 | 14 | 0 | 6 | 5 | 142 | 477 | 732 | 1209 | 144.1 | 159 | 1 | 8.4 | 14.3 | 50.1 | 20.2 | 0.5 | 7.8 | 92.9 | 0.644 | 0.644
 | Porter | Customer Service | [NAME] | 4 | 64 | 22 | 36 | 0 | 0 | 11 | 9 | 137 | 397 | 1218 | 1615 | 177.4 | 195.8 | 0.8 | 9.1 | 7.6 | 55.8 | 69.9 | 0.7 | 7.4 | 141.4 | 0.797 | 0.797
 | Porter | Customer Service | [NAME] | 22 | 9 | 21 | 12 | 9 | 0 | 8 |  | 81 | 268 | 595 | 863 | 153.4 | 168.4 | 0.5 | 5.6 | 13.7 | 60.7 | 30.9 | 0.1 | 15.6 | 121 | 0.788 | 0.788
 | Porter | Customer Service | [NAME] | 28 | 10 | 58 | 57 | 13 | 0 | 11 | 3 | 177 | 372 | 536 | 908 | 118.7 | 130.2 | 1.5 | 7.6 | 15.6 | 48.5 | 23.3 | 0.4 | 7.6 | 95.5 | 0.805 | 0.805
 | Porter | Customer Service | [NAME] | 24 | 2 | 53 | 11 | 7 | 0 | 2 | 0 | 99 | 392 | 557 | 949 | 126 | 130.2 | 0.8 | 7.5 | 20.7 | 39.6 | 15.9 | 0 | 9.3 | 85.5 | 0.679 | 0.679
 | Porter | Customer Service | Rosalind Fisher | 45 | 8 | 23 | 33 | 12 | 0 | 18 | 3 | 139 | 556 | 726 | 1282 | 156.2 | 178.5 | 0.9 | 8.2 | 26.1 | 58.8 | 30.6 | 0.1 | 9.6 | 125.2 | 0.802 | 0.802
 | Porter | Customer Service | Shanel Rosales | 33 | 2 | 53 | 29 | 10 | 0 | 8 | 6 | 135 | 438 | 840 | 1278 | 146.1 | 160.2 | 0.9 | 8.7 | 17.1 | 53.8 | 22.2 | 0.4 | 10.9 | 104.3 | 0.714 | 0.714
 | Porter | Customer Service | Thalia Pastrano | 12 | 48 | 17 | 27 | 10 | 0 | 0 |  | 114 | 276 | 860 | 1136 | 160.8 | 177.2 | 0.7 | 7.1 | 6.2 | 49.6 | 47.5 | 0 | 2.7 | 106.1 | 0.66 | 0.66
 | Price | Customer Service | [NAME] | 57 | 13 | 56 | 94 | 15 | 0 | 27 |  | 262 | 544 | 1363 | 1907 | 137 | 151.8 | 1.9 | 13.9 | 13.2 | 46.1 | 31.9 | 0.8 | 7.9 | 99.9 | 0.73 | 0.73
 | Price | Customer Service | Destiny Cornish | 47 | 6 | 21 | 27 | 0 | 0 | 2 | 0 | 103 | 477 | 697 | 1174 | 137.1 | 151.5 | 0.8 | 8.6 | 11.1 | 40.7 | 28.2 | 0.3 | 2.6 | 82.9 | 0.605 | 0.605
 | Price | Customer Service | [NAME] | 52 | 4 | 62 | 22 | 4 | 0 | 0 |  | 144 | 445 | 795 | 1240 | 156.1 | 172.9 | 0.9 | 7.9 | 10.6 | 58.5 | 30.8 | 0 | 3.4 | 103.3 | 0.661 | 0.661
 | Price | Customer Service | [NAME] | 32 | 8 | 30 | 29 | 6 | 0 | 5 | 1 | 110 | 354 | 841 | 1195 | 126.2 | 128.4 | 0.9 | 9.5 | 10 | 52.6 | 28.2 | 0.5 | 2.2 | 93.5 | 0.741 | 0.741
 | Price | Customer Service | [NAME] | 80 | 21 | 57 | 51 | 1 | 0 | 17 | 10 | 227 | 488 | 956 | 1444 | 160.8 | 178.2 | 1.4 | 9 | 11.2 | 48 | 40.4 | 0.2 | 2.9 | 102.8 | 0.639 | 0.639
 | Price | Customer Service | [NAME] | 42 | 1 | 15 | 39 | 19 | 0 | 2 | 5 | 118 | 550 | 1043 | 1593 | 155.9 | 172.7 | 0.8 | 10.2 | 10.6 | 49.4 | 25.5 | 1.5 | 11.4 | 98.4 | 0.632 | 0.632
 | Price | Customer Service | [NAME] | 51 | 11 | 52 | 50 | 3 | 0 | 7 | 5 | 174 | 426 | 896 | 1322 | 155.5 | 171.2 | 1.1 | 8.5 | 10.2 | 46.6 | 40.8 | 0.5 | 2.2 | 100.4 | 0.645 | 0.645
 | [NAME] | Customer Service | [NAME] | 43 | 8 | 42 | 52 | 0 | 0 | 12 | 1 | 157 | 431 | 903 | 1334 | 168 | 183.5 | 0.9 | 7.9 | 12.6 | 44.7 | 37.6 | 0.8 | 6.5 | 102.2 | 0.609 | 0.609
 | [NAME] | Customer Service | [NAME] | 27 | 11 | 57 | 53 | 20 | 0 | 10 | 3 | 178 | 437 | 1116 | 1553 | 159 | 173.9 | 1.1 | 9.8 | 11.6 | 54.6 | 38.2 | 0.5 | 6.1 | 111 | 0.698 | 0.698
 | [NAME] | Customer Service | [NAME] | 8 | 69 | 18 | 66 | 20 | 39 | 0 |  | 201 | 366 | 994 | 1360 | 167.4 | 184.3 | 1.2 | 8.1 | 6.3 | 64.2 | 52.9 | 0.2 | 7.1 | 130.7 | 0.781 | 0.781
 | [NAME] | Customer Service | [NAME] | 35 | 13 | 34 | 57 | 8 | 0 | 18 | 5 | 165 | 440 | 921 | 1361 | 166.4 | 180.5 | 1 | 8.2 | 11.8 | 53.5 | 39.7 | 0.4 | 8.6 | 113.9 | 0.685 | 0.685
 | [NAME] | Customer Service | [NAME] | 14 | 51 | 20 | 59 | 0 | 37 | 0 |  | 163 | 435 | 943 | 1378 | 167 | 184 | 1 | 8.2 | 7.5 | 58.1 | 43.2 | 1.1 | 9.6 | 119.5 | 0.715 | 0.715
 | [NAME] | Customer Service | [NAME] | 37 | 3 | 65 | 91 | 2 | 0 | 7 | 9 | 205 | 394 | 1115 | 1509 | 160.1 | 168.5 | 1.3 | 9.4 | 9.6 | 56.8 | 29.4 | 0.3 | 5.2 | 101.4 | 0.634 | 0.634
 | [NAME] | Customer Service | [NAME] | 43 | 7 | 32 | 44 | 7 | 0 | 5 | 1 | 138 | 338 | 677 | 1015 | 162.2 | 174.1 | 0.9 | 6.3 | 9.1 | 53.2 | 26.8 | 0.2 | 5.2 | 94.6 | 0.583 | 0.583