| Anchor | ||||
|---|---|---|---|---|
|
| Info | |||
|---|---|---|---|
Welcome to the highly requested Relationships Relationship guide! | BacktoTop | BacktoTop | main character
| Note |
|---|
WARNING. See Filtering |
...
...
If you jump back into the spreadsheet and certain events are “missing”. It means you have an active filter somewhere. Check the headings and clear any active filters. See Clearing Filters for help
Filtering
In order to filter, you first have to create a filter view.
Click on the (1) Cell A5 → (2) Data tab → (3) Filter Views → (4) Create new filter view
...
For tips on how to filter effectively check out these examples: Use Case 1, Use Case 2, Use Case 3
| Anchor |
|---|
...
|
To view filters, click icon shown in red, then “Create new filter view”. If done correctly the borders will blacken and you should see filter icons next to each column
...
Use Case
...
I would like to see all relationship events in Episode 1 only
Click the filter icon next to “Episode”
...
2. Ensure you have the “Filter by values” dropdown enabled (Red box). Deselect all apart from “1” and click “OK”.
Alternatively you can also filter by condition
...
Here, we will be applying the logic from Use Case 1 and Use Case 2
In no particular order, click the filter Icon next to Episode. Deselect everything apart from “1” and “2” and click “OK”
...
2. Then click the filter icon next to “Alannah”. Deselect “Blank” and click “OK”
...