Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Turn Times

Title | Date | Days | TurnTimeType | Modified | Item Type | Path
Purchase | 2020-10-07 00:00:00 | 2 | Conditions Review | 2020-10-09 08:35:19 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-07 00:00:00 | 2.5 | Initial LE | 2020-10-09 08:35:19 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-18 00:00:00 | 15 | New File Review | 2020-10-09 08:35:19 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-06 00:00:00 | 3 | Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-07 00:00:00 | 2.5 | Initial LE | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Conditions Review | 2020-10-09 08:35:19 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Closing Disclosures | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-07 00:00:00 | 2.5 | Re-Disclosure | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-02 00:00:00 | 5 | New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-08 00:00:00 | 1 | Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-18 00:00:00 | 15 | New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-08 00:00:00 | 1 | Funding Reviews | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-06 00:00:00 | 3 | Closing Disclosures | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Funding Reviews | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-07 00:00:00 | 2.5 | Re-Disclosure | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-02 00:00:00 | 5 | New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-07 00:00:00 | 2 | Novato-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Denver-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Novato-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Denver-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Denver-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Denver-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-30 00:00:00 | 7 | Denver-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Denver-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-02 00:00:00 | 5 | Novato-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-08 00:00:00 | 23 | Denver-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Denver-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-07 00:00:00 | 2 | Novato-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Novato-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-08 00:00:00 | 23 | Denver-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Novato-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-01 00:00:00 | 6 | Roseville 2-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-30 00:00:00 | 7 | Denver-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-25 00:00:00 | 10 | Roseville 1-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Roseville 1-Conditions Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Roseville 1-New File Review | 2020-10-09 08:35:20 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Novato-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Roseville 1-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Bellevue-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Roseville 1-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Bellevue-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Roseville 1-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-30 00:00:00 | 7 | Roseville 1-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-08-19 00:00:00 | 36 | Novato-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Roseville 1-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-01 00:00:00 | 6 | Roseville 2-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-08-12 00:00:00 | 41 | Roseville 1-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-08-19 00:00:00 | 36 | Novato-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-03 00:00:00 | 25 | Bellevue-New File Review | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times |  |  | as of 10/10/20
KOT | 2020-10-05 00:00:00 | 4 | Novato-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Bellevue-Conditions Review | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-01 00:00:00 | 6 | Roseville 1-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-10-05 00:00:00 | 4 | Roseville 2-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Roseville 2-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Roseville 2-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Roseville 2-Closing Disclosures | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Bellevue-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Roseville 2-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-01 00:00:00 | 6 | Roseville 2-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
KOT | 2020-10-05 00:00:00 | 4 | Bellevue-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Roseville 1-Doc Draw | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-08-13 00:00:00 | 40 | Roseville 2-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Roseville 2-New File Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1.5 | Denver-Doc Draw | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Portland-Doc Draw | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4.5 | Bellevue-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Novato-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-06 00:00:00 | 3 | Roseville 1-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Denver-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Roseville 1-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
[NAME] | 2020-09-17 00:00:00 | 16 | Roseville 2-New File Review | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-05 00:00:00 | 4 | Bellevue-New File Review | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | [NAME] | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Bellevue-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Novato-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-06 00:00:00 | 3 | Roseville 2-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Bellevue-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Bellevue-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Roseville 1-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-01 00:00:00 | 6 | Bellevue-Conditions Review | 2020-10-09 08:35:21 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-01 00:00:00 | 6 | Novato-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-08 00:00:00 | 1.5 | Denver-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Portland-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-03 00:00:00 | 25 | Bellevue-New File Review | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-30 00:00:00 | 7 | Bellevue-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Novato-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-07 00:00:00 | 2 | Portland-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Roseville 1-Funding Reviews | 2020-10-09 08:35:23 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Novato-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | [NAME] | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-02 00:00:00 | 5 | Portland-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Denver-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Portland-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Denver-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-02 00:00:00 | 5 | Bellevue-Closing Disclosures | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Roseville 1-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-09-30 00:00:00 | 7 | Portland-Doc Draw | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-07 00:00:00 | 2 | Bellevue-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Purchase | 2020-10-08 00:00:00 | 1 | Roseville 2-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Roseville 2-Funding Reviews | 2020-10-09 08:35:22 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Denver-Closing Disclosures | 2020-10-09 08:35:23 | Item | sites/turntimes/Lists/New Turn Times
Refinance | 2020-10-05 00:00:00 | 4 | Novato-Funding Reviews | 2020-10-09 08:35:23 | Item | sites/turntimes/Lists/New Turn Times