Hi @Zachary - the thing you’re referring to in Excel is a pretty cool feature that I believe is just considered part of Excel’s “Data Validation”. It’s more automatic than in Google Sheets. So while it doesn’t work exactly the same in Google Sheets where you can just use Alt+down arrow (Option+down arrow on Mac) out of the box, Google Sheets does also have a pretty good data validation in my opinion, but you have to take an extra step to enable it. So for example you can highlight your entire Tags column in the Transactions sheet and go to the menu path Data–>Data validation. Choose “New Rule” and it should immediately pick up all the entries in the column and pre-populate the criteria type as Dropdown with those values that it detected.
If you don’t prefer the default chip style, you can change that in the Advanced options menu before selecting Done to finish. You can also decide to just warn or reject a non-matching entry. It’s easy to add a new entry by clicking the pencil from within a cell. You can also create a Tags list somewhere else that you can then reference using the Criteria “Dropdown from a Range”. The interesting thing about that is you can sort and order the list however you want and the validation will automatically adjust.
1 Like