About 1,056,636 results (2,436 milliseconds)
Create an in-cell dropdown list - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/186103?hl=en&co=GENIE.Platform%3DDesktop Dropdown. On the Data validation rules panel, under "Criteria," select an option: Dropdown from a range: Choose the cells to include ...
Create an in-cell dropdown list - Android - Google Docs Editors Help
https://support.google.com/docs/answer/186103?hl=en&co=GENIE.Platform%3DAndroid Tap the cell or cells where you want to create a drop-down list. In the top right, tap More More . Tap Data Validation. Under "Criteria," choose an option: List ...
How to add a blank option in a data validation drop down list ...
https://support.google.com/docs/thread/5750893/how-to-add-a-blank-option-in-a-data-validation-drop-down-list?hl=en May 8, 2019 ... Report abuse. I use Excel but German language version, so my formular for the blank cell is a bit different: - ; Yes; No. Google user. Oct 8, ...
Sheets: Bulk Individual Data Validation Lists - Google Docs Editors ...
https://support.google.com/docs/thread/64469505/sheets-bulk-individual-data-validation-lists?hl=en Aug 13, 2020 ... I am attempting to build a lead intake form that includes a waiting list function when a location reaches capacity (hooray, COVID social distancing!)
I can't paste a list of items into the data validation box anymore ...
https://support.google.com/docs/thread/199098132/i-can-t-paste-a-list-of-items-into-the-data-validation-box-anymore?hl=en Jan 26, 2023 ... I have a Google Sheet in which I created a drop-down list that was populated by me selecting a cell, selecting Data > Data Validation from the Menu bar, and ...
My OFFSET, MATCH,COUNTIF Excel Formula won't work in Sheets ...
https://support.google.com/docs/thread/103447353/my-offset-match-countif-excel-formula-won-t-work-in-sheets?hl=en Mar 22, 2021 ... It sounds like you want to create dependent drop-down lists. In the Google Sheets Data > Data validation dialog box, the List from a range ...
Creating a Dependent Dropdown List - Google Docs Editors ...
https://support.google.com/docs/thread/197645995/creating-a-dependent-dropdown-list?hl=en Jan 17, 2023 ... Hello all, I've been trying to create a dependent data validation list ... Within Excel, I was able to create Named Excel Tables and Named ...
Dynamic Data Validation Listing - Google Docs Editors Community
https://support.google.com/docs/thread/256699859/dynamic-data-validation-listing?hl=en Feb 2, 2024 ... this will create a horizontal list in E2:BA2 based on the selection in Selections!B2. So if you select USA then that range will show all the ...
Multiple Data Validation Issue: LIST from RANGE and CUSTOM ...
https://support.google.com/docs/thread/49184818/multiple-data-validation-issue-list-from-range-and-custom-formula-how-do-you-do-this?hl=en May 25, 2020 ... I have a multiple data validation issue (sheet example below) that I cannot solve. How do you combine a CUSTOM FORMULA and a LIST from a Range together as a ...
Create a dropdown list in-cell using a formula - Google Docs Editors ...
https://support.google.com/docs/thread/208274024/create-a-dropdown-list-in-cell-using-a-formula?hl=en Mar 28, 2023 ... ... list via range from the data validation. Using data validation, I can't find a way to define the range so it excludes 1 of the cells that it ...
Create a dropdown list in-cell using a formula - Google Docs Editors ...
https://support.google.com/docs/thread/208274024/create-a-dropdown-list-in-cell-using-a-formula?hl=en Mar 28, 2023 ... ... list via range from the data validation. Using data validation, I can't find a way to define the range so it excludes 1 of the cells that it ...
Sheets Data Validation list based on formula - Google Docs Editors ...
https://support.google.com/docs/thread/152773678/sheets-data-validation-list-based-on-formula?hl=en Mar 1, 2022 ... In Excel I can create dynamic data validation dropdowns since I can base the validation on a formula but I can't seem to find a way to mimic it in Sheet.
Create an in-cell drop-down list - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/186103?hl=en-GB&co=GENIE.Platform%3DDesktop On the data validation rules panel, under 'Criteria', select an option: Drop-down from a range: Choose the cells to include in the list. Drop-down: Enter ...
data validation range disappears when uploading and converting to ...
https://support.google.com/drive/thread/4838964/data-validation-range-disappears-when-uploading-and-converting-to-google-docs?hl=en Apr 24, 2019 ... I have an excel file with cells with drop down list to select pre described data. ... I created an excel spreadsheet but when I download a ...
Data Validation doesn't auto increment the range entered in "list ...
https://support.google.com/docs/thread/13229111/data-validation-doesn-t-auto-increment-the-range-entered-in-list-from-range-when-dragging-to-copy?hl=en Aug 30, 2019 ... The issue is I want those two dropdowns to be created down 200+ rows. The first basic dropdown is fine when you drag copy it down rows. The ...
Order drop-down choices without changing original data order ...
https://support.google.com/docs/thread/129836572/order-drop-down-choices-without-changing-original-data-order?hl=en Oct 8, 2021 ... There is no way to directly sort the Data validation drop-down list. What is needed is to create a second list from the first list and sot that ...
Adding to Data Validation Dropdown Error - Google Docs Editors ...
https://support.google.com/docs/thread/197117720/adding-to-data-validation-dropdown-error?hl=en Jan 13, 2023 ... I am trying to add a new name to the data validation rules in a drop down list. I receive a message stating "Dropdown values need to be unique. Please remove ...
My dropdown list for "data validation rules" is in a wrong order ...
https://support.google.com/docs/thread/199859136/my-dropdown-list-for-data-validation-rules-is-in-a-wrong-order?hl=en Jan 31, 2023 ... I add a dropdown control for a range of cells. In the "Data validation rules" panel, I add 4 options, say A, B, C, D, to the dropdown list.
How to Select two ranges from "List From a Rang" Data Validation ...
https://support.google.com/docs/thread/176249473/how-to-select-two-ranges-from-list-from-a-rang-data-validation?hl=en Aug 23, 2022 ... Hello,. I was trying to create a drop down menu of selections for weekly meal prepping. I had gotten this sheet from online and ...
How do I revert back to the old style of google sheets data validation ...
https://support.google.com/docs/thread/194809540/how-do-i-revert-back-to-the-old-style-of-google-sheets-data-validation?hl=en Dec 28, 2022 ... ... add and adjust the previously set data validations throughout my spreadsheet. ... validation with a list (not the range) implies adding ...