Timeline for Can I have a drop-down list appear in a cell only if another cell contains a specific value?
Current License: CC BY-SA 4.0
9 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 6, 2023 at 23:41 | answer | added | Jeremy Adams | timeline score: 1 | |
Nov 1, 2021 at 8:24 | comment | added | doubleunary |
It is unclear whether column A is hand edited or contains formulas. If it is hand-edited, try the dependentDrowDownLists_ script.
|
|
Nov 1, 2021 at 2:50 | history | became hot network question | |||
Nov 1, 2021 at 1:45 | comment | added | Tedinoz | Hi and welcome. There are many precedents for the various steps involved in your scenario. How can I have onEdit trigger when specific cells are selected? will help with watching cell A2 and B2. Also Data validation Documentation includes an example of the code to build a Data Validatiuon range. | |
Oct 31, 2021 at 23:20 | comment | added | Rubén - Volunteer Moderator -♦ | Welcome to Web Applications. The only way to automatically add/remove the data-validation dropdown button is by using a Google Apps Script trigger. If you are not familiar with Google Apps Script triggers start by reading developers.google.com/apps-script/guides/sheets and developers.google.com/apps-script/guides/triggers, then try to use it to achieve your goal. If gets stuck, search for question about using Apps-Script and if needed, update this or post a new question. | |
Oct 31, 2021 at 23:10 | history | edited | Nathan96 | CC BY-SA 4.0 |
added 258 characters in body
|
Oct 31, 2021 at 19:36 | answer | added | Rubén - Volunteer Moderator -♦ | timeline score: 2 | |
S Oct 31, 2021 at 18:49 | review | First questions | |||
Oct 31, 2021 at 18:59 | |||||
S Oct 31, 2021 at 18:49 | history | asked | Nathan96 | CC BY-SA 4.0 |