We’re rewarding the question askers & reputations are being recalculated! Read more.

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.

24 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
1k 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 ...
2
votes
1answer
598 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 behaviour ...
2
votes
1answer
3k 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
2answers
32 views

Google Sheets Checkbox vs. Tickbox

Sometimes, I've seen Checkbox but I've also seen Tick Box. Does anyone know what's going on?
1
vote
2answers
473 views

How do you get current date to be added to a cell when a check box is checked in another cell

I want to get the current date added into a cell when a tick box is checked in another cell. I currently have another formula in the date cell which changes its colour when the tick box is checked, ...
1
vote
1answer
54 views

Populating alternatives in question 2 based on answers in question 1

I have ten people who sell something to companies, and I want to track what they do IN GOOGLE FORMS. Every agent has his own 10 companies that he contacts. So, in Question 1, I will have a drop-down ...
1
vote
1answer
67 views

Restrict entry to a group of cells based on the value in another cell

I am creating a work schedule where the staff enters their own schedules. I only want a certain number of staff each shift. I already use COUNTIF to show the number of staff signed up for each shift. ...
1
vote
1answer
1k views

How to combine FILTER with TRANSPOSE in data validation custom formula

Cells A2, C2, and E2 contain the data I want to make my custom list for data validation. Cells B2 and D2 have data I don't want in the list (just text - "vs" - in them). So, I'm trying to use the ...
0
votes
1answer
17 views

Checkbox that can display a checkmark or an X

Trying to make a checkbox that with one click it displays a check and with two clicks it will display an "x". is this possible? I've been looking for a way but the only thing I can find is a drop-...
0
votes
1answer
170 views

Dynamic Data Validation in Google Sheets

I want to restrict a value in a cell based on another cell in the same row. The value in A must not exceed what is in B. If the value in B is zero, any figure is allowed in A A | B --- 4 | 9 – ...
0
votes
2answers
16 views

Importing data found to be true from one Google sheet to another

I am trying to find a way to import data (text) from one sheet to another, via the same book. I assume it's going to need an IF or IFS formula because I only want data is that found to be "TRUE" (via ...
0
votes
1answer
206 views

Data validation if no then disable cell else drop-down lists

I'm trying to do a drop-down list IF another cell doesn't equal "no" So I have two columns: one with a drop-down list containing "yes" and "no" and in the other column I want to do a drop-down list ...
0
votes
1answer
44 views

Copy data validation “list of items” from one sheet to another?

On one sheet I have a column that uses "list of items" data validation which allows for a drop-down menu to extend and a multiple of options to be selected. Is there a way to automatically populate ...
0
votes
1answer
82 views

How to apply conditional data validation when a cell with a defined value is changed?

I have a spreadsheet that's basically a grid checklist, let's say 10 columns and 20 rows. There are multiple cells that have N/A as the value, and I'm worried going through the checklist that one ...
0
votes
1answer
387 views

Using checkbox to copy data form worksheet A to worksheet B

I am trying to use the new Checkbox function in Google Sheets. I can't figure out how If I click the checkbox in A9 on Worksheet 2 I want the Text in A10 and the $ amount in A11 to be copied to cells ...
0
votes
1answer
18 views

If checked, add row to data chart?

Basically, I have been working on some automated solutions to show the date and data for the most recent 4 weeks on this data sheet. There are still some bugs to work out, but the last thing I need to ...
0
votes
1answer
40 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
773 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 ...
0
votes
2answers
2k 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 ...
0
votes
2answers
56 views

Check button in Google Spreadsheets specific for each user

I have a Google Spreadsheet with different tasks. I want to implement a check button in the following way: My intention is that the users can't edit the spreadsheet but they have to be able to use ...
0
votes
1answer
101 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 ...
0
votes
1answer
22 views

Data Validation for Sheet1 from Sheet2 list

I'm trying to figure out how to validate data entries in one column on sheet 1 from a database I created in sheet 2. In column A sheet 1 the user is allowed to type in a string, upon completion it ...
-1
votes
1answer
27 views

How to turn checkbox with IF formula?

I have a cell with an "end date" and I have a checkbox under an "Inactive" labelled column. I would like that checkbox to turn on when today's date is after the end date. I can't seem to add a ...
-1
votes
1answer
13 views

Sorting column A with drop-down and column B with checkbox

I have a spreadsheet that I use to run a foosball tournament, and in column A I have a dropdown data validation that will let me select a players name. In Column B I have a checkbox that I check once ...