1
00:00:00,080 --> 00:00:04,267
A shared tracker has a dropdown with Open, Pending, and Closed,

2
00:00:04,267 --> 00:00:07,312
but a pasted list contains Paused and Waiting.

3
00:00:07,312 --> 00:00:11,499
Whether those values arrived before the rule, through a warning setting,

4
00:00:11,499 --> 00:00:15,686
or with a paste that changed formatting, the useful question is

5
00:00:15,686 --> 00:00:17,589
which rows require review now.

6
00:00:17,589 --> 00:00:21,776
We will audit the fictional column without silently replacing source values.

7
00:00:22,376 --> 00:00:26,534
Paste the fictional five-ticket table from the practice card into a

8
00:00:26,534 --> 00:00:31,039
disposable Google Sheet and put the three approved statuses in E2 through E4.

9
00:00:31,039 --> 00:00:32,771
Read each status word exactly.

10
00:00:32,771 --> 00:00:36,583
Do not change Paused or Waiting yet, because the answer check

11
00:00:36,583 --> 00:00:40,048
needs those two near misses to prove the audit works.

12
00:00:40,048 --> 00:00:45,245
A dropdown's colored appearance is not enough to establish the stored text is valid.

13
00:00:45,845 --> 00:00:49,006
Select the status range and inspect Data validation.

14
00:00:49,006 --> 00:00:53,746
Google's dropdown help says a rule can reject invalid typed values

15
00:00:53,746 --> 00:00:58,091
or merely warn; confirm the selected range and chosen behavior rather

16
00:00:58,091 --> 00:01:01,251
than assuming a visible chip guarantees clean history.

17
00:01:01,251 --> 00:01:05,596
If a paste replaced a rule, restore the intended rule in

18
00:01:05,596 --> 00:01:09,547
the disposable copy before relying on it for future entries.

19
00:01:10,147 --> 00:01:14,277
In C2 enter the exact formula shown and fill through C6.

20
00:01:14,277 --> 00:01:19,908
COUNTIF checks whether the current B-cell value appears in the approved E2:E4 list.

21
00:01:19,908 --> 00:01:24,038
IF returns REVIEW when the count is zero and OK otherwise.

22
00:01:24,038 --> 00:01:28,168
The dollar signs keep the allowlist fixed while the B reference

23
00:01:28,168 --> 00:01:29,670
moves row by row.

24
00:01:29,670 --> 00:01:32,673
This audit does not alter the original statuses.

25
00:01:33,273 --> 00:01:37,169
C2 through C6 should read OK, REVIEW, OK, REVIEW, OK.

26
00:01:37,169 --> 00:01:42,234
The REVIEW rows are S-102 with Paused and S-104 with Waiting.

27
00:01:42,234 --> 00:01:46,519
Check the IDs, not just the count of two; a copied

28
00:01:46,519 --> 00:01:51,194
formula starting on the wrong row could produce an apparently plausible total.

29
00:01:51,194 --> 00:01:56,648
Consult the owner of the tracker before mapping either word to an approved status.

30
00:01:57,248 --> 00:02:01,546
After deciding what Paused and Waiting mean, edit only the reviewed

31
00:02:01,546 --> 00:02:05,062
practice rows and confirm every audit cell becomes OK.

32
00:02:05,062 --> 00:02:09,360
If the real workflow needs to reject future invalid entries, set

33
00:02:09,360 --> 00:02:14,049
that behavior in the validation rule and test with a disposable row.

34
00:02:14,049 --> 00:02:18,738
The lesson's claim is narrow: it identifies current mismatches, not that

35
00:02:18,738 --> 00:02:21,473
any particular paste path is automatically blocked.