Questions tagged [data-validation]
Use when the topic is the process of cleaning, correcting and filtering input to reach a state suitable for the operation of a program.
0
votes
1answer
18 views
Can I hide the dropdown arrows from Data Validation in Google Sheets?
I use Data Validation with List from a range set up on all my rows in a column to be able to choose a "Category"
The arrows however, are annoying to see - especially on cells I haven't yet filled.
...
0
votes
1answer
18 views
If I set the school to “School A” then only School A's classes should be visible
I have created a progress tracker for the Academy Trust I work in. The trust at the moment consist of 4 schools. Students move between the schools as the progress and between classes during the year ...
0
votes
0answers
16 views
Data Validation Custom Formula
I'm trying to create a drop-down menu that is dependent on a previous cell in a row.
The data coming in from a DB is M or F. Male or female. Then from what is displayed there I want the next column ...
1
vote
1answer
85 views
Is it possible to create a Named Range that is the union of two other Named Ranges?
Say I have two named ranges,
team_a_coaches
team_a_players
Is it possible to have another named range,
team_a
and define it as the union of the first two named ranges?
The goal would be that if I ...
2
votes
1answer
1k views
Data Validation with an IF formula
I've got a list of items that I want to include in a Drop Down. Using data validation, all I need to do is add the range and this works. However, the list has various types of data and I want to ...
0
votes
1answer
495 views
Google Sheets data validation dropdown will not show if cell contains formula
I have a data validation dropdown with a list of possible values, and if the cell is empty or has a value, the dropdown list will show correctly.
But if the cell contains a formula, the dropdown ...
0
votes
2answers
411 views
Disable a cell when A cell is blank
I want to create a google spreadsheet where I have 2 columns involve. The scenario is:
in my A column, I can input and column B has a drop down. What I want to do is disable column B unless column A ...
1
vote
1answer
2k views
How to validate a date in Google Forms?
Google Forms include the possibility to perform some sort of validation on user input for checkboxes and text; the functionality is available very easily both via the UI and the API. Unfortunately, it ...
1
vote
0answers
210 views
Any way to separately Validate and create a Dropdowns in Google Sheets?
Sample Scenario:
Sheet 1 has a 3 Dropdowns from sheet 2
Sheet 2 has two lists, {"A";"B"}, and a second dynamic list that copies the first IF the value doesn't already appear on sheet 1
The behavior ...
0
votes
1answer
498 views
Google sheet data validation, text only
I want to make a column (lets say column A) that you can only enter text into it, and reject all numbers.
I have tried "custom" and "=istext()" for the formula... other options don't seem to work
...
1
vote
1answer
23 views
Google Sheets Dropdown using Multiple Sets of Data
On a Google Sheet, I want to have a dropdown list of options to choose from. However, these options are split into different sections and so I would need to select multiple sets of data. I can get the ...
2
votes
1answer
2k views
Copy data validation rules with relative references using a script
I'm looking for a way to copy my data validation the following way.
If validation for Main sheet A1 is:
Cell Range: MainSheet!J1
List from range: ListValues!1:1
I need validation for main sheet A2 ...
1
vote
1answer
68 views
Grab data values from Row with max value
First step I do is find the column row with the max value through =MAX(A1:a10).
Let's say it's A7 that has the max value.
Once I have that value, I would like some data from the rest of row 7 to be ...
2
votes
1answer
195 views
Duplicate sheet references original sheet's range for validation
When you set up an in-cell drop down list using Data Validation that references an existing range of cells within your spreadsheet as the criteria, by clicking Data > Validation and choosing List from ...
-1
votes
1answer
334 views
In Google Sheets, I'm trying to create a drop down that reads from 2 columns but returns from 1 column [duplicate]
Basically, I have store number and Store name. I want to be able to start typing a name and select the name, but only show the store number.
If that is not possible, then I thought I can combine ...
1
vote
1answer
287 views
Data Validation rule to enforce first day of a month
I have a Google Sheet in which users key in records for a specific month. A report on another tab looks up the month and consolidates it. I'm trying to enforce using the first day of the month to ...
4
votes
0answers
651 views
Google Forms Answer Validation Based On Another Previous Given Answer
I am working on a form in Google Forms.
At some point during my form, I need to validate an answer based in a previous answer.
To make it more clear, I give you an example:
How many hours do you ...
1
vote
1answer
335 views
Validate with “List from a range” only if another cell is not empty on Google Sheets
I would like to use validation "List from a range" in all the cells of column B only if in the correspondent cell in column A there is data in it.
Is there a way to do it?
0
votes
1answer
79 views
Can I limit a text field in Cognito Forms to NOT allow alpha characters?
I have a question on a form that the only answer would be a single number, or a list of numbers. "1" or "1,3,4,17,26", etc. Is it possible to not allow alpha characters in the field. I'm trying to ...
2
votes
1answer
342 views
Google Sheets - How to format numerical contents of data validation list?
I'm using Data Validation to give the user a list of valid prices they can select from. These are on their sheet in "financial" format such as
2.00
2.50
3.00
etc. But in the actual dropdown menu, ...
4
votes
2answers
2k views
Dropdown list based on the result of another cell's dropdown
I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet.
E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
2
votes
1answer
743 views
Is there a way to dynamically populate a dropdown depending on the value of other cells?
Is there a way to populate a dropdown list differently depending on the values of another cell? For example, the dropdown in A2 contains Movies and Sports. I want the dropdown in A3 to have Horror and ...
2
votes
1answer
5k views
How to set Custom data validation in Google Sheets (A really simple step-by-step guide needed)
I'm trying to figure out how to create custom data validation in Google Sheets what are the steps I need to follow to achieve this?
For example if I wanted the following validation:
// Set the data ...
0
votes
1answer
127 views
How do I have the choice made in an in-cell drop down menu affect the cells next to it?
I have a contact sheet with names going down the list and contact info in the cells to the right of each name.
On a separate signup sheet, I used data validation to create a drop down menu with the ...
2
votes
1answer
398 views
Google-speadsheet data validation to restrict to Mondays only
I have a field in Google Sheets I labeled "Week of". I want to restrict user input to a date (mm/dd/yyyy) which is a Monday. I can set "Data validation" -> "criteria" to "Date" but how do I limit it ...
2
votes
1answer
1k views
Limit values to other ranges
I'm trying to create a Sheets that defines various objects, and these objects sometimes reference each other (equivalent to SQL foreign key).
Is there a way that I can limit the values of a cell, to ...
