Skip to main content
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