Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Web Applications

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.

40 questions
info Newest Frequent Votes Active Unanswered
0
votes
1answer
9 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
15 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 ...
1
vote
1answer
11 views

Conditional Google Sheet Checkbox

I am creating a spreadsheet which can track all of the replacement items I am sending out for my business, however, I also want to be able to track my refunds on the same spreadsheet. I have got it so ...
1
vote
1answer
11 views

Conditional Format Copying in Google Sheets

I am looking to copy over a conditional format that changes the colour of an array of cells when checking a checkbox. This works perfectly fine on the first checkbox. However, when I try to replace ...
0
votes
1answer
12 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
vote
1answer
18 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 ...
0
votes
2answers
18 views

Flag rows that are duplicates in two columns

My question is similar to this one, but adds a little more complexity. How can I flag duplicate entries in a Google Sheets column unless the duplicates have different values in another column? For ...
0
votes
1answer
14 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 ...
1
vote
1answer
10 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. ...
0
votes
0answers
8 views

Email sheet and keep data validation format intact

I created a sheet in Google with check boxes and drop down menus. Now I need to email that sheet to another organization. But when I do, it drops all of the "special" formatting I put in place. Is ...
1
vote
1answer
36 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 ...
1
vote
1answer
9 views

Max number in a column

I haven't been able to find an answer to this because I don't know how to word the search terms. How do I prevent a cell from going above the number 300,000? It is simply the sum of one column ...
0
votes
1answer
125 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
25 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
282 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 ...
2
votes
1answer
274 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 ...
1
vote
1answer
301 views

How do you link the value of a checkbox to another checkbox

I am using the checkbox feature in Google Sheets and I have another checkbox that I would like to be ticked when the original one is ticked. I tried using the formula where the original checkbox is ...
2
votes
1answer
2k 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
604 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
675 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
46 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 ...
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 ...
2
votes
1answer
257 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
1answer
581 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
26 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
107 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
234 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
372 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
322 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
754 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
363 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
82 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
383 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 the user does not make a choice from D20 dropdown menu, therefore F20 ...
2
votes
1answer
785 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
132 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
438 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 ...