'Google Sheets Dropdown "Input must fall within specified range". How to solve this?
I have a very simple Dropdown on Google Sheets that is working perfectly. Basically when I select an item from the dropdown, it will output that same item on another cell.
Works with dropdown items (see image)
However, I also want to write a custom text (that is not available in the dropdown) to be outputed.
Here's what I mean exactly:
Not working when entering a custom text (see image)
But I'm getting an error.
Is there a code that if you enter a text that is not in the specified range, it would display the text without an error?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|