Hello everyone,
I am currently facing an issue with the dropdown menu in Google Sheets. The problem I’m encountering is that the dropdown menu doesn’t display all the options that are present in my table.
I read about another user’s experience who had a similar problem and managed to resolve it by changing the format from numeric to text. However, I need to use a numeric format for my values, so I cannot adopt this solution.
Interestingly, my situation is a bit different. The options I have in my dropdown menu are distinct both in terms of values and formats. This makes me wonder if the format is truly the issue.
If you could take a look at the sheet directly to better understand the problem, I’ve included the link below: https://docs.google.com/spreadsheets/d/1imw1ND1qO2zYXqdoIGIzErg4kG2Dk8xkCSDrNO3VDl0/edit?usp=sharing
