Questions tagged [google-sheets-data-validation]

For questions involving issues with Data Validation (a set of validation rules restricting cell's input) in Google Sheets.

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

How to check if there is any Data Validation error in the whole spreadsheet?

Is there a way to check in a Google Sheets spreadsheet, if there is at least one cell violating a Data Validation rule? If such functionality is not built-into the app, how can I write a Google Apps ...
0
votes
0answers
18 views

Reject an input in a cell based on some value

I tried to create a roster sheet to my company. Eg. In the Z column there are 3 shifts A,B,C. I put a strength count below such that when an employee mark L instead of A or B or C , the strength get ...
0
votes
0answers
32 views

Google Spreadsheet cell value dependant on other cell value

I am trying to make on cell value dependent on another cell value in the same row. I have a Project List spreadsheet with Data Validation list in column B with several Project Status (IE: Urgent, ...
0
votes
1answer
13 views

Google Sheets data validation help

I am trying to do this simple thing in Google Sheets with data validation, so what I want to do is not allow people to put negative numbers and numbers with decimals. I've been trying a lot of ...
0
votes
1answer
48 views

Auto numbering Google sheets

I want to have auto numbering dependent on cell drop down box in helper column so i can sorted out. If someone pick Start in A2 to have number 1 in B2. Then if they skip one or two and chose Start ...
2
votes
1answer
306 views

“Invalid Input, must be item on specified list” Google sheets error

I am super new to anything coding and google sheets. All of what I've done was was trying to follow the directions of another question I saw on this site. However, as expected, nothing is working! ...
2
votes
2answers
74 views

How to pull values from another sheet for dynamic Data validation

This one is far out of my league. To simplify things: Sheet1 B4 has a Data validation drop down list Ex. Vancouver, Surrey, Burnaby, etc B5 has a Data validation drop down list Ex. 500, 1000, 2000, ...
1
vote
1answer
53 views

Set editing permissions per column, per user Google Sheets

I have a Google Sheet that's being edited by 3 people, but each person needs to edit only one column. EX Red will edit red column; Blue will edit blue column and Yellow, well, yellow column hahaha. ...
0
votes
1answer
87 views

How to detect duplicates across multiple sheets?

I have found a couple of formulas/scripts for what I am looking for, but they are all locked for one sheet only, thus I will try to explain what exactly I need. I am unable to do it my self, because ...
1
vote
1answer
13 views

Create list by cell color

I have a master list of trading cards. I'd love to be able to use a color coding system. For example, if Green is cards I've already collected, when I highlight the background of the cell green, I ...
-1
votes
1answer
15 views

Stop drop-down box errors

So I'm trying to use the drop-down menus to restrict human input, but there is a formula than can fill in those cells with information that I don't want humans to be able to enter in. The formula does ...
1
vote
1answer
22 views

How can I merge drop-down columns in Google Sheets?

Please see Investment Portfolio Tracker - TMOAP Official Version 5.2. If the three columns (in red rectangles) remain the same for rows 5-20, it's obviously foolish and unproductive to click on the ...
0
votes
2answers
72 views

Dropdown list created from a list in one cell

Is it possible to create a dropdown list from only one cell as a source? Each element separated by commas?
1
vote
2answers
326 views

How can we make a field (Cell) value mandatory if another field (cell) have specific value, while submitting the data?

I am developing a small attendance app in Google Sheets. Each day after choosing their name or team, the supervisor will see a list of their employees to update their attendance status. The list will ...
0
votes
2answers
212 views

Using a checkbox to auto-populate a row on another sheet

I have this spreadsheet which is used for receiving and recording work. SST responses sheet is where people submit requests, Workload is where we record all work. I'm wanting it so that when someone ...
0
votes
2answers
365 views

Data Validation in Google Sheets Using Multiple Criteria

I have a column with text in the format: [text:more text/numbers] I want to ensure whatever is entered into the cell conforms to this syntax, or at least as much of it as possible. text is always 5 ...
0
votes
0answers
50 views

Validation of cell values

I have a problem (like everyone here, obviosly). In the sheet in the column E from row 2 (row 1 is the heading) I have to choose some text: Text1, Text2... Depending on the choice of value (it should ...
1
vote
1answer
13 views

Data validation choices triggering formulas in other cells

I'm trying to create a dynamic supplies cost list to help calculate the costs of our recipes whenever we switch suppliers. The idea is to enter the unit price (say of oil - see screenshot), then use a ...
1
vote
1answer
20 views

Google Sheets Circular Dropdown Dependency

Suppose we have 2 columns Id & Name which contained in sheet1. Now in sheet2 have dropdown for Id & Name which user can select and it Lookup value for each other (select Id from dropdown, Name ...
0
votes
1answer
372 views

Drop-down list from cell formula (not data validation)

I am trying to make a triplet dependent drop-list. The first is a typical drop down but the next two are dynamic. Since you cannot enter a formula into the data validation criteria, how can you ...
1
vote
1answer
1k views

Named range in Data validation

I am having trouble getting a named range to work in the data-validation criteria selection. Given that my named range is "ContactRecord" and the rangeid=1234567890, in the data-validation criteria ...
1
vote
1answer
114 views

Is there a way to display named ranges with a space?

Sample spreadsheet here. In the spreadsheet, there is a dependent drop-down list in the first column, which automatically populates a data validation for the second column using the named range from ...
0
votes
1answer
941 views

View all validation rules

I've just created Data Validation for the named range. How can I edit the validation? I tried to click Data Validation... on the range, but there is a new validation rule, but not existing for the ...
0
votes
2answers
465 views

Protect spreadsheet against duplicate data and sheet addition/deletion

There are some people that love to troll and spam my Google spreadsheet with useless info. Google Sheet lacks granular permission restriction. I need to prevent duplicate data from being submitted. I ...
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 ...
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 ...
2
votes
2answers
271 views

How can you find or highlight all cells having validation in Google Sheets?

My spreadsheet has several cells that have had validation applied to them, but it would be nice to recheck them or switch the validation to a complimentary cell. After searching on Google and looking ...