Spreadsheet: 735384d1622919270-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
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 13:24:00 | T | F
TOP003 | 2021-01-20 16:41:00 | F | T
TOP003 | 2021-02-22 16:54:00 | T | F
TOP005 | 2021-02-03 17:58:00 | T | F
TOP005 | 2021-02-08 11:41:00 | F | T
TOP005 | 2021-02-22 16:53:00 | T | F
TOP007 | 2021-01-07 13:25:00 | T | F
TOP007 | 2021-01-08 17:40:00 | F | T
TOP007 | 2021-02-22 16:51:00 | T | F
TOP013 | 2021-01-07 13:25:00 | T | F
TOP014 | 2021-01-22 15:44:00 | F | T
TOP014 | 2021-03-04 11:50:00 | T | F
TOP015 | 2021-01-22 15:44:00 | F | T
TOP015 | 2021-02-15 10:17:00 | T | F
TOP016 | 2021-02-26 16:15:00 | F | T
TOP016 | 2021-03-04 12:01:00 | T | F
TOP017 | 2021-03-17 13:02:00 | F | T
TOP017 | 2021-03-19 18:07:00 | T | F
TOP017 | 2021-05-12 14:42:00 | F | T
TOP017 | 2021-05-13 11:24:00 | T | F
TOP017 | 2021-05-25 12:17:00 | F | T
TOP017 | 2021-05-26 17:43:00 | T | F
TOP018 | 2021-01-12 14:03:00 | F | T
TOP018 | 2021-03-18 15:37:00 | T | F
TOP019 | 2021-01-04 00:00:00 | F | T
TOP019 | 2021-02-09 13:13:00 | T | F
TOP019 | 2021-01-12 16:39:00 | F | T
TOP019 | 2021-02-23 11:15:00 | T | F
TOP020 | 2021-01-19 17:26:00 | F | T
TOP020 | 2021-02-22 14:52:00 | T | F
TOP021 | 2021-01-19 13:44:00 | F | T
TOP021 | 2021-02-01 12:20: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 11:59:00 | T | F
TOP024 | 2021-01-06 00:00:00 | T | F
TOP024 | 2021-02-24 15:38:00 | T | F
TOP025 | 2021-02-05 16:25:00 | F | T
TOP025 | 2021-02-18 09:44:00 | T | F
TOP026 | 2021-01-07 00:00:00 | T | F
TOP026 | 2021-02-24 15:40:00 | T | F
TOP027 | 2021-01-07 13:22:00 | T | F
TOP027 | 2021-02-24 15:40:00 | T | F
TOP028 | 2021-02-04 11:25:00 | F | T
TOP028 | 2021-02-05 16:28:00 | T | F
TOP028 | 2021-02-12 17:38:00 | F | T
TOP028 | 2021-02-18 09:45:00 | T | F
TOP028 | 2021-04-30 13:10:00 | F | T
TOP028 | 2021-05-06 14:34:00 | T | F
TOP029 | 2021-02-03 16:32:00 | F | T
TOP029 | 2021-02-05 16:30:00 | T | F
TOP029 | 2021-04-30 13:11:00 | F | T
TOP030 | 2021-01-07 13:23:00 | T | F
TOP030 | 2021-02-01 12:03:00 | F | T
TOP030 | 2021-02-24 15:39:00 | T | F
TOP031 | 2021-02-24 15:39:00 | T | F
TOP032 | 2021-04-30 13:09:00 | F | T
TOP032 | 2021-05-06 14:33:00 | T | F
TOP033 | 2021-02-22 16:57:00 | T | F
TOP034 | 2021-01-07 13:29:00 | T | F
TOP034 | 2021-02-22 16:58:00 | T | F
TOP035 | 2021-01-07 13:28:00 | T | F
TOP035 | 2021-02-22 16:59:00 | T | F
TOP035 | 2021-02-25 17:01:00 | T | F
TOP036 | 2021-01-19 16:34:00 | T | F
TOP036 | 2021-02-01 12:05:00 | F | T
TOP036 | 2021-02-24 16:49:00 | T | F
TOP037 | 2021-01-22 14:53:00 | F | T
TOP037 | 2021-01-26 18:10:00 | T | F
TOP037 | 2021-02-12 17:32:00 | F | T
TOP037 | 2021-03-04 09:31:00 | T | F
TOP037 | 2021-04-30 13:12:00 | F | T
TOP037 | 2021-05-14 11:04:00 | T | F
TOP038 | 2021-03-04 17:23:00 | T | F
TOP039 | 2021-03-22 13:23:00 | T | F
TOP039 | 2021-04-23 17:03:00 | F | T
TOP039 | 2021-04-30 13:13:00 | T | F
TOP040 | 2021-03-22 13:24:00 | T | F
TOP040 | 2021-04-30 13:13:00 | F | T
TOP040 | 2021-05-06 14:24:00 | T | F
TOP040 | 2021-05-07 16:02:00 | F | T
TOP041 | 2021-03-04 17:22:00 | T | F
TOP042 | 2021-01-20 21:47:00 | F | T
TOP042 | 2021-01-26 18:09:00 | T | F
TOP042 | 2021-03-02 11:50:00 | F | T
TOP042 | 2021-03-09 11:17:00 | T | F
TOP042 | 2021-04-23 17:02:00 | F | T
TOP042 | 2021-04-30 13:13:00 | T | F
TOP043 | 2021-02-03 14:33:00 | F | T
TOP043 | 2021-02-05 16:32:00 | T | F
TOP044 | 2021-02-24 15:31:00 | T | F
TOP045 | 2021-02-24 15:31:00 | T | F
TOP046 | 2021-02-24 15:31:00 | T | F
TOP046 | 2021-03-25 13:45:00 | F | T
TOP046 | 2021-04-21 16:16:00 | T | F
TOP047 | 2021-02-03 09:43:00 | F | T
TOP047 | 2021-02-05 16:37:00 | T | F
TOP047 | 2021-02-26 18:17:00 | F | T
TOP047 | 2021-03-16 12:07:00 | T | F
TOP047 | 2021-04-23 17:38:00 | F | T
TOP048 | 2021-02-26 18:18:00 | F | T
TOP048 | 2021-03-22 13:24:00 | T | F
TOP048 | 2021-04-30 13:14:00 | F | T
TOP048 | 2021-05-06 14:26:00 | T | F
TOP048 | 2021-05-07 16:03:00 | F | T
TOP048 | 2021-06-02 15:23:00 | T | F
TOP049 | 2021-02-24 15:32:00 | T | F
TOP050 | 2021-02-22 16:49:00 | T | F
TOP051 | 2021-02-22 16:49:00 | T | F
TOP052 | 2021-02-22 16:47:00 | T | F
TOP053 | 2021-01-07 13:23:00 | T | F
TOP054 | 2021-05-01 10:38:00 | F | T
TOP054 | 2021-05-06 15:23:00 | T | F
TOP055 | 2021-02-01 14:57:00 | F | T
TOP055 | 2021-03-04 11:49:00 | T | F
TOP056 | 2021-05-01 10:39:00 | F | T
TOP056 | 2021-05-06 15:23:00 | T | F
TOP057 | 2021-01-07 13:26:00 | T | F
TOP057 | 2021-04-30 13:07:00 | F | T
TOP057 | 2021-05-06 14:29:00 | T | F
TOP058 | 2021-04-30 13:08:00 | F | T
TOP058 | 2021-05-06 14:29:00 | T | F
TOP059 | 2021-05-01 10:40:00 | F | T
TOP059 | 2021-05-06 15:24:00 | T | F
TOP060 | 2021-01-07 13:27:00 | T | F
TOP060 | 2021-02-14 21:08:00 | F | T
TOP060 | 2021-02-18 09:47:00 | T | F
TOP060 | 2021-04-30 13:06:00 | F | T
TOP060 | 2021-05-06 14:27:00 | T | F