Short question: Is there any way to include an "other" option in a dynamic drop down list without having to add it to the source data?
Long question:
I have a table of locations that with a field titled ListName. This is the match/count field when using an offset formula as the dynamic drop-down list --> OFFSET(Locations[[#Headers],[Name]],MATCH(ListName,Locations[ListName],0),0,COUNTIF(Locations[ListName],ListName),1)
Within the table, there are 130 different ListName values.... thus, 130 different possible drop-down lists.
I need each drop-down list to also have an "other" option (though it would say something like "New Location Needed").
Is there a way to achieve that without having to add 130 new records to the table .... a "NewLocation" code for every possible ListName (Preferably, without VBA) ?
Long question:
I have a table of locations that with a field titled ListName. This is the match/count field when using an offset formula as the dynamic drop-down list --> OFFSET(Locations[[#Headers],[Name]],MATCH(ListName,Locations[ListName],0),0,COUNTIF(Locations[ListName],ListName),1)
Within the table, there are 130 different ListName values.... thus, 130 different possible drop-down lists.
I need each drop-down list to also have an "other" option (though it would say something like "New Location Needed").
Is there a way to achieve that without having to add 130 new records to the table .... a "NewLocation" code for every possible ListName (Preferably, without VBA) ?