1 00:00:00,080 --> 00:00:03,720 You are checking only your open tickets, but a regular filter 2 00:00:03,720 --> 00:00:06,699 on a shared Sheet can change what collaborators see. 3 00:00:06,699 --> 00:00:10,340 In this fictional tracker, the target is two rows: T dash 4 00:00:10,340 --> 00:00:13,318 one zero two and T dash one zero five. 5 00:00:13,318 --> 00:00:16,959 We will create a filter view, name it, and check that 6 00:00:16,959 --> 00:00:20,930 the underlying six-row table remains untouched when we close the view. 7 00:00:21,530 --> 00:00:25,341 The download has six fictional support tickets with Ticket, Status, 8 00:00:25,341 --> 00:00:26,865 Owner, and Topic columns. 9 00:00:26,865 --> 00:00:30,295 We want Status equals Open and Owner equals Casey. 10 00:00:30,295 --> 00:00:34,487 Read the whole table before filtering, especially the Waiting row for 11 00:00:34,487 --> 00:00:37,917 Casey and the Open rows owned by other people. 12 00:00:37,917 --> 00:00:43,252 Those near matches are what make the answer check useful instead of merely decorative. 13 00:00:43,852 --> 00:00:47,035 Move the fictional data into a native Google Sheet. 14 00:00:47,035 --> 00:00:50,925 With the table selected, open Data and choose Create filter view. 15 00:00:50,925 --> 00:00:55,169 Google describes this as a way to filter only your own view. 16 00:00:55,169 --> 00:00:59,413 A dark filter-view bar or its current equivalent distinguishes it from 17 00:00:59,413 --> 00:01:01,535 the ordinary Create a filter command. 18 00:01:01,535 --> 00:01:04,365 Keep the header row in the selected range. 19 00:01:04,965 --> 00:01:08,964 In the filter view, use the Status column control to keep Open. 20 00:01:08,964 --> 00:01:10,964 Then use Owner to keep Casey. 21 00:01:10,964 --> 00:01:14,630 Do not sort the original data or hide source rows manually. 22 00:01:14,630 --> 00:01:18,296 Because each filter combines with the other, the result should shrink 23 00:01:18,296 --> 00:01:19,962 to exactly two ticket IDs. 24 00:01:19,962 --> 00:01:23,628 If you see T dash one zero six, Waiting was not 25 00:01:23,628 --> 00:01:27,961 excluded; if you see T dash one zero four, Owner was not narrowed. 26 00:01:28,561 --> 00:01:32,296 Name this view Open — Casey, then use Save View if 27 00:01:32,296 --> 00:01:35,284 your current Google Sheets interface shows that button. 28 00:01:35,284 --> 00:01:39,019 Google also documents reopening a view from Data, Change view. 29 00:01:39,019 --> 00:01:43,502 A meaningful name makes it easier to return without rebuilding both conditions. 30 00:01:43,502 --> 00:01:47,610 If you have only view permission, Google says your temporary filter 31 00:01:47,610 --> 00:01:49,105 view is not saved. 32 00:01:49,705 --> 00:01:53,780 The expected filtered rows are T dash one zero two, an 33 00:01:53,780 --> 00:01:57,855 Open login ticket owned by Casey, and T dash one zero 34 00:01:57,855 --> 00:02:00,819 five, an Open report ticket owned by Casey. 35 00:02:00,819 --> 00:02:03,041 There should be no third row. 36 00:02:03,041 --> 00:02:06,746 Compare the IDs against the independent answer sheet rather than 37 00:02:06,746 --> 00:02:08,969 trusting a row-count badge alone. 38 00:02:08,969 --> 00:02:11,933 The source CSV still contains all six tickets. 39 00:02:12,533 --> 00:02:17,754 Close the filter view using its top-right control and inspect the original tracker. 40 00:02:17,754 --> 00:02:19,992 All six fictional rows should remain. 41 00:02:19,992 --> 00:02:25,214 Reopen the saved view through Data, Change view, if your account has edit access. 42 00:02:25,214 --> 00:02:29,317 A filter view controls presentation; it is not a privacy boundary, 43 00:02:29,317 --> 00:02:33,420 because people with file access can still see the source data. 44 00:02:33,420 --> 00:02:35,658 Use sharing permissions for access decisions.