Adding Items in Table for Data Validation Menu

Copper Contributor

I have a couple tables that I'm using as the source for some Data Validation drop down menus. If I want to add items to these tables and have them automatically update in the drop down menus, I'm having to insert the items somewhere below the first cell and above the last cell. If I try to insert an item above the first item or below the last item (even though it's still in the "table" and the table automatically expands), those items don't update in my drop down menu. Why is this? Is there something I can do to make this work?

1 Reply
Hello Adam,
Assuming your items are Item1 to Item4 and are listed in A1:A4, name your list as “Items” with this formula:
=INDEX($A:$A,1):INDEX($A:$A,COUNTA($A:$A))
In the cell where you want to place your drop-down list, your source is:
=Items
Thereafter, any item that you add before Item1, after Item4, or anywhere between them, shall be automatically included in your drop-down list.