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
Solved! Go to Solution.
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.
@Lorenzo_Caporali
ORDERBY() expression can be used with either Key columns or Ref columns. To sort ordinary column values, you need to use the SORT() expression.
the column I am trying to sort is a Ref column. Sorry if I didnโt specify it in my original post.
My expression was something like: ORDERBY(table[key column], [label]). But my problem is not sorting the values, the problem is to get ALL the values from the original spreadsheet!
Do the missing rows in the dropdown have values in the key column in the spreadsheet?
Yes, they do. The table has just two columns the key values and the label values.
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.
sigh Thatโs a frequent problemโฆ
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |