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.

25 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
2k 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
767 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 ...
1
vote
2answers
50 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
1answer
151 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
128 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
2k 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
0answers
8 views

Why do Google Sheets filter ranges sometimes auto-expand to include new data, and sometimes don't?

When I create a filter in Google sheets, I want the range to automatically expand as I add/populate new rows. Sometimes, this works fine: When I have a column using “Checkbox” data validation (...
0
votes
0answers
39 views

Google Sheets Data Validation with List Dependencies

Is this even possible with Google Sheets? I've looked around and found some explanations on how to accomplish this by using scripts. However, the issue remains because I'm unable to have my script ...
0
votes
0answers
19 views

How to use SORT function on existing data, and not make a copy of it

I am following this tutorial to sort data using a drop down menu and a check box. My only issue is that I want to use this method on the original set of data, and not make a copy of it. I would really ...
0
votes
1answer
23 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
428 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
20 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
494 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
415 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
128 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
770 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
19 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
47 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
977 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
69 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
121 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
25 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
51 views

Sheets: Condense a column with empty cells

I have a Google Sheet with multiple columns and some of the columns have empty cells at arbitrary locations. I want to 'condense' the columns, that is, simply shift upwards all cells in the column so ...
-1
votes
1answer
31 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
14 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 ...