Mar 27, 2024
Google Sheet - Drop Downs and Data Validation
Details
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Mar 27, 2024
Creating a column of numbers for 0-99 is very easy - just put this formula in a cell that is empty for 99 rows below that cell:
=SEQUENCE(100,1,0)
Then point to this range with your data validation criteria set to "Dropdown from range", as I've done with cells B4:B23 in tab Main.
Pasting your list of players names is not a Sheets technique, but basic computer skills. If you have an email, a PDF, or some other computer based list of the players names for a particular team, "select, copy, and paste" that list of values into a column in your spreadsheet. As I've done with the three rosters on the Rosters tab.
Then if you just want that one roster to be the values for the dropdowns, you can point to it directly with your data validation "Dropdown from a range" rule.
In the example I gave, I allow you to pick different teams - but only one at a time - to be used for the data validation values, by selecting the team name in cell B1 of tab Main.
Does this explanation help?
Original Poster Clayton Greenberg marked this as an answer
All Replies (2)
Hi, Clayton Greenberg,
You can paste the names into an empty column (I usually do it in its own sheet (tab)) and then use the 'Dropdown (from range)' option.
Hope this helps!
--
When you've received a response that answers your question, please observe these forum courtesies:
• Leave your demo sheet shared as part of this solution's archive
• Recommend answers to your post by clicking 'Yes' for "Is this helpful?"
• Post again soon!
Mar 27, 2024
Hi, Clayton Greenberg,
Yes, but you'll have to manually select every other cell and then go to Data > Data Validation instead of right-clicking. Alternatively, you can add the dropdowns to the entire column and then select every other row and hit BACKSPACE to remove the dropdown from some rows.
Hope this helps!
--
When you've received a response that answers your question, please observe these forum courtesies:
• Leave your demo sheet shared as part of this solution's archive
• Recommend answers to your post by clicking 'Yes' for "Is this helpful?"
• Post again soon!
Mar 27, 2024
Yes, I always recommend using "Dropdown from range" as opposed to "Dropdown".
Import (or cut and paste) your visiting team rosters, and save them, perhaps even on a dedicated tab, Rosters, for visiting rosters. Then you could have a single column on that tab as the data validation range, referenced by your main tab where you want to be able to select the names.
By selecting, a team name, you could automatically fill in your reserved "dropdown range" with all of the member names from the team you selected. Then your main sheet would see just those names as valid values in its dropdowns.
Does this make sense?
Does that do what you need?
Cheers,
Gill
Mar 27, 2024
Creating a column of numbers for 0-99 is very easy - just put this formula in a cell that is empty for 99 rows below that cell:
=SEQUENCE(100,1,0)
Then point to this range with your data validation criteria set to "Dropdown from range", as I've done with cells B4:B23 in tab Main.
Pasting your list of players names is not a Sheets technique, but basic computer skills. If you have an email, a PDF, or some other computer based list of the players names for a particular team, "select, copy, and paste" that list of values into a column in your spreadsheet. As I've done with the three rosters on the Rosters tab.
Then if you just want that one roster to be the values for the dropdowns, you can point to it directly with your data validation "Dropdown from a range" rule.
In the example I gave, I allow you to pick different teams - but only one at a time - to be used for the data validation values, by selecting the team name in cell B1 of tab Main.
Does this explanation help?
Original Poster Clayton Greenberg marked this as an answer