VALID_IF DROPDOWNS FROM A LIST IN A EXTERNAL ...

[Andrea_Sala]

VALID_IF DROPDOWNS FROM A LIST IN A EXTERNAL SPREADSHEET

Hello! I have a list of value in an external spreadsheet saved on my Drive. It is a 5.000> rows spreadsheet and 100 columns.

With VALID_IF constrains it is possibile to limit the user input to a single value choosen from that external SPREADSHEET.

Do you think is going to be slow? Are there any workaround?

More info: The spreadsheet is created with an IMPORTHTML expression that grabs the data from the Italian National statistical Institute (ISTAT) and it is automatically updated when data changes… Fortunately, data changes rarely (only once or twice per year).