Stack Exchange Network

Stack Exchange network consists of 175 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

Questions tagged [google-sheets-data-validation]

0
votes
2answers
11 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
19 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
272 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 ...
1
vote
1answer
545 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
16 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
0answers
42 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 ...