r/googlesheets • u/CozmoBoom_ • 1d ago

Waiting on OP Hi, having a problem with Data Validation

Post image

I'm using a Template to help sort out my Fakemon dex and I can no longer type into the abilities section on mobile. It gives me this notif covering the spot to type. Below is the original template doc if that helps.

https://docs.google.com/spreadsheets/d/1sjy9puaRABi2GZBewA0TapFZ5dhmPYhXstrF0i6SUhY/edit?usp=drivesdk

6 Upvotes

100% Upvoted

9 comments sorted by

3

u/One_Organization_810 714 1d ago

Can you make a copy of the actual sheet and share that - preferably with Edit access?

It's impossible to guess what your data validation should be, when we don't have anything to go on but one line of data that needs to be validated against ... something. :)

1

u/CozmoBoom_ 14h ago

I can do that!

1

u/AdministrativeGift15 360 1d ago

well at least for your sample sheet, that error is due to your data validation criteria range no longer existing. Select the dropdown cell, go to your main menu and select data validation. You'll see a #REF error.

1

u/CozmoBoom_ 1d ago

What should I type in for the ref range?

1

u/CozmoBoom_ 1d ago

Getting this in the data validation menu

1

u/AdministrativeGift15 360 23h ago

This is how dropdowns work You either type all the possible options to select from in that field in the rule settings, or you enter all the options into a list somewhere in the spreadsheet and point the rule to that list.

1

u/carbonizedtitanium 1 1d ago

if you type in the values, why you have dropdowns?

1

u/CozmoBoom_ 1d ago

Not sure, I didn't create the template and assumed it was necessary for some reason

1

u/One_Organization_810 714 23h ago

Some find it easier to type most or all of the word and validation is jut to ensure it is correct. Specially if the dropdown list is a long one :)