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.

17 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
53 views

Copy Multiple Cells with Data Validation from one Google Sheets to Another

I need to copy the data validation info from a column in Google Sheet (multiple cells in that column with data validation) to another Google Sheet. When doing the regular copy/paste or copy/paste Data ...
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 ...
1
vote
1answer
16 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 ...
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 sort by drop down option and secondary date range

I have a data validation range (drop down) list. I'm using a query to bring back info from the choice of that drop down. I would like to then filter the information further with a date range that will ...
0
votes
0answers
178 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
25 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
69 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
17 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
675 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 ...
0
votes
2answers
202 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?
0
votes
2answers
376 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
743 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
votes
1answer
25 views

Create multiple menu dropdowns based upon 1st rollover, 2nd rollover, 3rd rollover etc

Example: User selects a cell for dropdown. Dropdown shows A,B,C,D,E,F. Upon rollover of B, a new 2nd dropdown populates with RED, BLUE, GREEN, PURPLE. Upon rolling over GREEN, a new dropdown ...
-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
18 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 ...