Spreadsheet: 787179d1657657007-trying-to-filter-out-information-into-a-new-sheet-tasks-and-projects2
Sheet: Tasks & Projects

TASKS & PROJECTS |  |  | ACCOUNTABILITY AND CONSISTENCY |  |  |  |  |  |  |  |  |  |  | Employee List
 |  |  | Tasks |  |  |  |  | Overdue | Pending | Done | Total Tasks | Today's Date
 |  |  | # | Done | Tasks | Captain | Assistants | Priority | Due Date | Status | Days Left | Notes
 | Highlight Filters |  | 1 | False | task 1 | EMP 1 |  |  | 2022-07-18 00:00:00 | In Progress |  |  |  | Employee/s
 |  |  | 2 | False | task 2 | EMP 3 | EMP 1 & EMP 2 |  | 2022-07-18 00:00:00 | 50% done
 |  |  | 3 | False | task 3 | EMP 1 |  |  | 2022-07-18 00:00:00 | Needs Attention |  |  |  | # | Label | Tasks Pending | Progress
 |  |  | 4 | False | task 4 | EMP 2 |  |  | 2022-07-18 00:00:00
 |  |  | 5 | False | task 5 | EMP 3 | EMP 1 & EMP 2 |  | 2022-07-18 00:00:00 |  |  |  |  | 1 | EMP 1
 |  |  | 6 | False | task 6 | EMP 3 |  |  | 2022-07-18 00:00:00 |  |  |  |  | 2 | EMP 2 |  | .
 |  |  | 7 | False | task 7 | EMP 3 |  |  | 2022-07-18 00:00:00 |  |  |  |  | 3 | EMP 3
 |  |  | 8 | False | task 8 | EMP 4 |  |  | 2022-07-18 00:00:00 | Paused |  |  |  | 4 | EMP 4
 |  |  | 9 | False | task 9 | EMP 2 |  |  | 2022-07-18 00:00:00 |  |  |  |  | 5
 |  |  | 10 | False | task 10 | EMP 2 |  |  | 2022-07-25 00:00:00 |  |  |  |  | 6
 |  |  | 11 | False | task 11 | EMP 4 | EMP 1 & EMP 2 |  | 2022-07-25 00:00:00 |  |  |  |  | 7
 |  |  | 12 | False |  |  |  |  |  |  |  |  |  | 8
 |  |  | 13 | False |  |  |  |  |  |  |  |  |  | 9
 |  |  | 14 | False |  |  |  |  |  |  |  |  |  | 10
 |  |  | 15 | False |  |  |  |  |  |  |  |  |  | 11
 |  |  | 16 | False |  |  |  |  |  |  |  |  |  | 12
 |  |  | 17 | False |  |  |  |  |  |  |  |  |  | 13
 |  |  | 18 | False |  |  |  |  |  |  |  |  |  | 14
 |  |  | 19 | False |  |  |  |  |  |  |  |  |  | 15
 |  |  | 20 | False |  |  |  |  |  |  |  |  |  | COUNTIF(Table3[Captain]:Table3[Assistants],"*"&P13&"*")
 |  |  | 21 | False
 |  |  | 22 | False
 |  |  | 23 | False
 |  |  | 24 | False
 |  |  | 25 | False
 |  |  | 26 | False |  |  |  |  |  |  |  | may need someone to write scripts
 |  |  | 27 | False |  |  |  |  |  |  |  | Image & vector limitations
 |  |  | 28 | False
 |  |  | 29 | False
 |  |  | 30 | False
 |  |  | 31 | False
 |  |  | 32 | False
 |  |  | 33 | False
 |  |  | 34 | False
 |  |  | 35 | False
 |  |  | 36 | False
 |  |  | 37 | False
 |  |  | 38 | False
 |  |  | 39 | False
 |  |  | 40 | False
 |  |  | 41 | False
 |  |  | 42 | False
 |  |  | 43 | False
 |  |  | 44 | False
 |  |  | 45 | False
 |  |  | 46 | False
 |  |  | 47 | False
 |  |  | 48 | False
 |  |  | 49 | False
 |  |  | 50 | False
 |  |  | 51 | False
 |  |  | 52 | False
 |  |  | 53 | False
 |  |  | 54 | False
 |  |  | 55 | False
 |  |  | 56 | False
 |  |  | 57 | False
 |  |  | 58 | False
 |  |  | 59 | False
 |  |  | 60 | False
 |  |  | 61 | False
 |  |  | 62 | False
 |  |  | 63 | False
 |  |  | 64 | False
 |  |  | 65 | False
 |  |  | 66 | False
 |  |  | 67 | False
 |  |  | 68 | False
 |  |  | 69 | False
 |  |  | 70 | False
 |  |  | 71 | False
 |  |  | 72 | False
 |  |  | 73 | False
 |  |  | 74 | False
 |  |  | 75 | False
 |  |  | 76 | False
 |  |  | 77 | False
 |  |  | 78 | False
 |  |  | 79 | False
 |  |  | 80 | False
 |  |  | 81 | False
 |  |  | 82 | False
 |  |  | 83 | False
 |  |  | 84 | False
 |  |  | 85 | False
 |  |  | 86 | False
 |  |  | 87 | False
 |  |  | 88 | False
 |  |  | 89 | False
 |  |  | 90 | False
 |  |  | 91 | False
 |  |  | 92 | False
 |  |  | 93 | False
 |  |  | 94 | False
 |  |  | 95 | False
 |  |  | 96 | False
 |  |  | 97 | False
 |  |  | 98 | False
 |  |  | 99 | False
 |  |  | 100 | False
 |  |  | 101 | False
 |  |  | 102 | False
 |  |  | 103 | False
 |  |  | 104 | False
 |  |  | 105 | False
 |  |  | 106 | False
 |  |  | 107 | False
 |  |  | 108 | False
 |  |  | 109 | False
 |  |  | 110 | False
 |  |  | 111 | False
 |  |  | 112 | False
 |  |  | 113 | False
 |  |  | 114 | False
 |  |  | 115 | False
 |  |  | 116 | False
 |  |  | 117 | False
 |  |  | 118 | False
 |  |  | 119 | False
 |  |  | 120 | False
 |  |  | 121 | False
 |  |  | 122 | False
 |  |  | 123 | False
 |  |  | 124 | False
 |  |  | 125 | False
 |  |  | 126 | False
 |  |  | 127 | False
 |  |  | 128 | False
 |  |  | 129 | False
 |  |  | 130 | False
 |  |  | 131 | False
 |  |  | 132 | False
 |  |  | 133 | False
 |  |  | 134 | False
 |  |  | 135 | False
 |  |  | 136 | False
 |  |  | 137 | False
 |  |  | 138 | False
 |  |  | 139 | False
 |  |  | 140 | False
 |  |  | 141 | False
 |  |  | 142 | False
 |  |  | 143 | False
 |  |  | 144 | False
 |  |  | 145 | False
 |  |  | 146 | False
 |  |  | 147 | False
 |  |  | 148 | False
 |  |  | 149 | False
 |  |  | 150 | False
 |  |  | 151 | False
 |  |  | 152 | False
 |  |  | 153 | False
 |  |  | 154 | False
 |  |  | 155 | False
 |  |  | 156 | False
 |  |  | 157 | False
 |  |  | 158 | False
 |  |  | 159 | False
 |  |  | 160 | False
 |  |  | 161 | False
 |  |  | 162 | False
 |  |  | 163 | False
 |  |  | 164 | False
 |  |  | 165 | False
 |  |  | 166 | False
 |  |  | 167 | False
 |  |  | 168 | False
 |  |  | 169 | False
 |  |  | 170 | False
 |  |  | 171 | False
 |  |  | 172 | False
 |  |  | 173 | False
 |  |  | 174 | False
 |  |  | 175 | False
 |  |  | 176 | False
 |  |  | 177 | False
 |  |  | 178 | False
 |  |  | 179 | False
 |  |  | 180 | False
 |  |  | 181 | False
 |  |  | 182 | False
 |  |  | 183 | False
 |  |  | 184 | False
 |  |  | 185 | False
 |  |  | 186 | False
 |  |  | 187 | False
 |  |  | 188 | False
 |  |  | 189 | False
 |  |  | 190 | False
 |  |  | 191 | False
 |  |  | 192 | False
 |  |  | 193 | False
 |  |  | 194 | False
 |  |  | 195 | False
 |  |  | 196 | False
 |  |  | 197 | False
 |  |  | 198 | False
 |  |  | 199 | False
 |  |  | 200 | False
 |  |  | 201 | False
 |  |  | 202 | False
 |  |  | 203 | False
 |  |  | 204 | False
 |  |  | 205 | False
 |  |  | 206 | False
 |  |  | 207 | False
 |  |  | 208 | False
 |  |  | 209 | False
 |  |  | 210 | False
 |  |  | 211 | False
 |  |  | 212 | False
 |  |  | 213 | False
 |  |  | 214 | False
 |  |  | 215 | False
 |  |  | 216 | False
 |  |  | 217 | False
 |  |  | 218 | False
 |  |  | 219 | False
 |  |  | 220 | False
 |  |  | 221 | False
 |  |  | 222 | False
 |  |  | 223 | False
 |  |  | 224 | False
 |  |  | 225 | False
 |  |  | 226 | False
 |  |  | 227 | False
 |  |  | 228 | False
 |  |  | 229 | False
 |  |  | 230 | False
 |  |  | 231 | False
 |  |  | 232 | False
 |  |  | 233 | False
 |  |  | 234 | False
 |  |  | 235 | False
 |  |  | 236 | False
 |  |  | 237 | False
 |  |  | 238 | False
 |  |  | 239 | False
 |  |  | 240 | False
 |  |  | 241 | False
 |  |  | 242 | False
 |  |  | 243 | False
 |  |  | 244 | False
 |  |  | 245 | False
 |  |  | 246 | False
 |  |  | 247 | False
 |  |  | 248 | False
 |  |  | 249 | False
 |  |  | 250 | False
 |  |  | 251 | False
 |  |  | 252 | False
 |  |  | 253 | False
 |  |  | 254 | False
 |  |  | 255 | False
 |  |  | 256 | False
 |  |  | 257 | False
 |  |  | 258 | False
 |  |  | 259 | False
 |  |  | 260 | False
 |  |  | 261 | False
 |  |  | 262 | False
 |  |  | 263 | False
 |  |  | 264 | False
 |  |  | 265 | False
 |  |  | 266 | False
 |  |  | 267 | False
 |  |  | 268 | False
 |  |  | 269 | False
 |  |  | 270 | False
 |  |  | 271 | False
 |  |  | 272 | False
 |  |  | 273 | False
 |  |  | 274 | False
 |  |  | 275 | False
 |  |  | 276 | False
 |  |  | 277 | False
 |  |  | 278 | False
 |  |  | 279 | False
 |  |  | 280 | False
 |  |  | 281 | False
 |  |  | 282 | False
 |  |  | 283 | False
 |  |  | 284 | False
 |  |  | 285 | False
 |  |  | 286 | False
 |  |  | 287 | False
 |  |  | 288 | False
 |  |  | 289 | False
 |  |  | 290 | False
 |  |  | 291 | False
 |  |  | 292 | False
 |  |  | 293 | False
 |  |  | 294 | False
 |  |  | 295 | False
 |  |  | 296 | False
 |  |  | 297 | False
 |  |  | 298 | False
 |  |  | 299 | False
 |  |  | 300 | False
 |  |  | 301 | False
 |  |  | 302 | False
 |  |  | 303 | False
 |  |  | 304 | False
 |  |  | 305 | False
 |  |  | 306 | False
 |  |  | 307 | False
 |  |  | 308 | False
 |  |  | 309 | False
 |  |  | 310 | False
 |  |  | 311 | False
 |  |  | 312 | False
 |  |  | 313 | False
 |  |  | 314 | False
 |  |  | 315 | False
 |  |  | 316 | False
 |  |  | 317 | False
 |  |  | 318 | False
 |  |  | 319 | False
 |  |  | 320 | False
 |  |  | 321 | False
 |  |  | 322 | False
 |  |  | 323 | False
 |  |  | 324 | False
 |  |  | 325 | False
 |  |  | 326 | False
 |  |  | 327 | False
 |  |  | 328 | False
 |  |  | 329 | False
 |  |  | 330 | False
 |  |  | 331 | False
 |  |  | 332 | False
 |  |  | 333 | False
 |  |  | 334 | False
 |  |  | 335 | False
 |  |  | 336 | False
 |  |  | 337 | False
 |  |  | 338 | False
 |  |  | 339 | False
 |  |  | 340 | False
 |  |  | 341 | False
 |  |  | 342 | False
 |  |  | 343 | False
 |  |  | 344 | False
 |  |  | 345 | False
 |  |  | 346 | False
 |  |  | 347 | False
 |  |  | 348 | False
 |  |  | 349 | False
 |  |  | 350 | False
 |  |  | 351 | False
 |  |  | 352 | False
 |  |  | 353 | False
 |  |  | 354 | False
 |  |  | 355 | False
 |  |  | 356 | False
 |  |  | 357 | False
 |  |  | 358 | False
 |  |  | 359 | False
 |  |  | 360 | False
 |  |  | 361 | False
 |  |  | 362 | False
 |  |  | 363 | False
 |  |  | 364 | False
 |  |  | 365 | False
 |  |  | 366 | False
 |  |  | 367 | False
 |  |  | 368 | False
 |  |  | 369 | False
 |  |  | 370 | False
 |  |  | 371 | False
 |  |  | 372 | False
 |  |  | 373 | False
 |  |  | 374 | False
 |  |  | 375 | False
 |  |  | 376 | False
 |  |  | 377 | False
 |  |  | 378 | False
 |  |  | 379 | False
 |  |  | 380 | False
 |  |  | 381 | False
 |  |  | 382 | False
 |  |  | 383 | False
 |  |  | 384 | False
 |  |  | 385 | False
 |  |  | 386 | False
 |  |  | 387 | False
 |  |  | 388 | False
 |  |  | 389 | False
 |  |  | 390 | False
 |  |  | 391 | False
 |  |  | 392 | False