Spreadsheet: 735386d1622922727-auto-populate-field-for-whole-year-based-on-2-criterias-of-t-f-and-name-impossible-new-template
Sheet: Input

Name | Date Changed | Old Value | New Value |  | Dates Only | Copied to B
TOP001 | 2021-01-07 00:00:00 | T | F
TOP001 | 2021-01-22 00:00:00 | F | T
TOP001 | 2021-02-22 00:00:00 | T | F
TOP003 | 2021-01-07 00:00:00 | T | F
TOP003 | 2021-01-20 00:00:00 | F | T
TOP003 | 2021-02-22 00:00:00 | T | F
TOP005 | 2021-02-03 00:00:00 | T | F
TOP005 | 2021-02-08 00:00:00 | F | T
TOP005 | 2021-02-22 00:00:00 | T | F
TOP007 | 2021-01-07 00:00:00 | T | F
TOP007 | 2021-01-08 00:00:00 | F | T
TOP007 | 2021-02-22 00:00:00 | T | F
TOP013 | 2021-01-07 00:00:00 | T | F
TOP014 | 2021-01-22 00:00:00 | F | T
TOP014 | 2021-03-04 00:00:00 | T | F
TOP015 | 2021-01-22 00:00:00 | F | T
TOP015 | 2021-02-15 00:00:00 | T | F
TOP016 | 2021-02-26 00:00:00 | F | T
TOP016 | 2021-03-04 00:00:00 | T | F
TOP017 | 2021-03-17 00:00:00 | F | T
TOP017 | 2021-03-19 00:00:00 | T | F
TOP017 | 2021-05-12 00:00:00 | F | T
TOP017 | 2021-05-13 00:00:00 | T | F
TOP017 | 2021-05-25 00:00:00 | F | T
TOP017 | 2021-05-26 00:00:00 | T | F
TOP018 | 2021-01-12 00:00:00 | F | T
TOP018 | 2021-03-18 00:00:00 | T | F
TOP019 | 2021-01-04 00:00:00 | F | T
TOP019 | 2021-02-09 00:00:00 | T | F
TOP019 | 2021-01-12 00:00:00 | F | T
TOP019 | 2021-02-23 00:00:00 | T | F
TOP020 | 2021-01-19 00:00:00 | F | T
TOP020 | 2021-02-22 00:00:00 | T | F
TOP021 | 2021-01-19 00:00:00 | F | T
TOP021 | 2021-02-01 00:00:00 | T | F
TOP022 | 2021-01-06 00:00:00 | T | F
TOP022 | 2021-03-28 00:00:00 | F | T
TOP022 | 2021-01-05 00:00:00 | F | T
TOP022 | 2021-05-04 00:00:00 | T | F
TOP023 | 2021-01-05 00:00:00 | F | T
TOP023 | 2021-02-02 00:00:00 | T | F
TOP024 | 2021-01-06 00:00:00 | T | F
TOP024 | 2021-02-24 00:00:00 | T | F
TOP025 | 2021-02-05 00:00:00 | F | T
TOP025 | 2021-02-18 00:00:00 | T | F
TOP026 | 2021-01-07 00:00:00 | T | F
TOP026 | 2021-02-24 00:00:00 | T | F
TOP027 | 2021-01-07 00:00:00 | T | F
TOP027 | 2021-02-24 00:00:00 | T | F
TOP028 | 2021-02-04 00:00:00 | F | T
TOP028 | 2021-02-05 00:00:00 | T | F
TOP028 | 2021-02-12 00:00:00 | F | T
TOP028 | 2021-02-18 00:00:00 | T | F
TOP028 | 2021-04-30 00:00:00 | F | T
TOP028 | 2021-05-06 00:00:00 | T | F
TOP029 | 2021-02-03 00:00:00 | F | T
TOP029 | 2021-02-05 00:00:00 | T | F
TOP029 | 2021-04-30 00:00:00 | F | T
TOP030 | 2021-01-07 00:00:00 | T | F
TOP030 | 2021-02-01 00:00:00 | F | T
TOP030 | 2021-02-24 00:00:00 | T | F
TOP031 | 2021-02-24 00:00:00 | T | F
TOP032 | 2021-04-30 00:00:00 | F | T
TOP032 | 2021-05-06 00:00:00 | T | F
TOP033 | 2021-02-22 00:00:00 | T | F
TOP034 | 2021-01-07 00:00:00 | T | F
TOP034 | 2021-02-22 00:00:00 | T | F
TOP035 | 2021-01-07 00:00:00 | T | F
TOP035 | 2021-02-22 00:00:00 | T | F
TOP035 | 2021-02-25 00:00:00 | T | F
TOP036 | 2021-01-19 00:00:00 | T | F
TOP036 | 2021-02-01 00:00:00 | F | T
TOP036 | 2021-02-24 00:00:00 | T | F
TOP037 | 2021-01-22 00:00:00 | F | T
TOP037 | 2021-01-26 00:00:00 | T | F
TOP037 | 2021-02-12 00:00:00 | F | T
TOP037 | 2021-03-04 00:00:00 | T | F
TOP037 | 2021-04-30 00:00:00 | F | T
TOP037 | 2021-05-14 00:00:00 | T | F
TOP038 | 2021-03-04 00:00:00 | T | F
TOP039 | 2021-03-22 00:00:00 | T | F
TOP039 | 2021-04-23 00:00:00 | F | T
TOP039 | 2021-04-30 00:00:00 | T | F
TOP040 | 2021-03-22 00:00:00 | T | F
TOP040 | 2021-04-30 00:00:00 | F | T
TOP040 | 2021-05-06 00:00:00 | T | F
TOP040 | 2021-05-07 00:00:00 | F | T
TOP041 | 2021-03-04 00:00:00 | T | F
TOP042 | 2021-01-20 00:00:00 | F | T
TOP042 | 2021-01-26 00:00:00 | T | F
TOP042 | 2021-03-02 00:00:00 | F | T
TOP042 | 2021-03-09 00:00:00 | T | F
TOP042 | 2021-04-23 00:00:00 | F | T
TOP042 | 2021-04-30 00:00:00 | T | F
TOP043 | 2021-02-03 00:00:00 | F | T
TOP043 | 2021-02-05 00:00:00 | T | F
TOP044 | 2021-02-24 00:00:00 | T | F
TOP045 | 2021-02-24 00:00:00 | T | F
TOP046 | 2021-02-24 00:00:00 | T | F
TOP046 | 2021-03-25 00:00:00 | F | T
TOP046 | 2021-04-21 00:00:00 | T | F
TOP047 | 2021-02-03 00:00:00 | F | T
TOP047 | 2021-02-05 00:00:00 | T | F
TOP047 | 2021-02-26 00:00:00 | F | T
TOP047 | 2021-03-16 00:00:00 | T | F
TOP047 | 2021-04-23 00:00:00 | F | T
TOP048 | 2021-02-26 00:00:00 | F | T
TOP048 | 2021-03-22 00:00:00 | T | F
TOP048 | 2021-04-30 00:00:00 | F | T
TOP048 | 2021-05-06 00:00:00 | T | F
TOP048 | 2021-05-07 00:00:00 | F | T
TOP048 | 2021-06-02 00:00:00 | T | F
TOP049 | 2021-02-24 00:00:00 | T | F
TOP050 | 2021-02-22 00:00:00 | T | F
TOP051 | 2021-02-22 00:00:00 | T | F
TOP052 | 2021-02-22 00:00:00 | T | F
TOP053 | 2021-01-07 00:00:00 | T | F
TOP054 | 2021-05-01 00:00:00 | F | T
TOP054 | 2021-05-06 00:00:00 | T | F
TOP055 | 2021-02-01 00:00:00 | F | T
TOP055 | 2021-03-04 00:00:00 | T | F
TOP056 | 2021-05-01 00:00:00 | F | T
TOP056 | 2021-05-06 00:00:00 | T | F
TOP057 | 2021-01-07 00:00:00 | T | F
TOP057 | 2021-04-30 00:00:00 | F | T
TOP057 | 2021-05-06 00:00:00 | T | F
TOP058 | 2021-04-30 00:00:00 | F | T
TOP058 | 2021-05-06 00:00:00 | T | F
TOP059 | 2021-05-01 00:00:00 | F | T
TOP059 | 2021-05-06 00:00:00 | T | F
TOP060 | 2021-01-07 00:00:00 | T | F
TOP060 | 2021-02-14 00:00:00 | F | T
TOP060 | 2021-02-18 00:00:00 | T | F
TOP060 | 2021-04-30 00:00:00 | F | T
TOP060 | 2021-05-06 00:00:00 | T | F