Solved: My dropdown does not include all the values in the... - Page 2

Lorenzo_Caporal · 07-06-2020 10:06 AM

Hi, I have a big problem:
I have a dropdown to select a row from a table, but it does not include all the values in the original google sheet. Is this a known bug, or is it something else?
The table I am trying to get the data from has more than 800 rows, and it hasn’t any security filters.
Additionally, when I tried to order the values of the dropdown using “ORDERBY()” in the “VALID IF” menu, the result presented many errors. Therefore I had to get rid of the “ORDERBY()” expression, and do it manually.
Thank you for your attention

Lorenzo_Caporal

I managed to resolve my problem: the issue was that google sheets formatted my unique_IDs as numbers, and not as text (as it was supposed to be). Therefore, there were some duplicated IDs in my original spreadsheet. Once I realized it, I corrected this issue, and now everything works fine.

View solution in original post

My dropdown does not include all the values in the table