D
D
DarckGraf7772021-09-27 16:06:40
Google Sheets
DarckGraf777, 2021-09-27 16:06:40

Google Sheets when entering a value in a cell - a model window with a choice of how much to add?

Good day to all.

Tell me, can anyone come across, on the Internet it has not yet been possible to find such a script.
The following is necessary:
​​There is a table columns - ID, Date 1, Date 2, Responsible, Comment, Status
For example, the first 10 lines are filled.

It is necessary that the script, after entering "Everyone" in line 11 and in the column Responsible, pops up a modal window with a drop-down checkbox list (multiple choice, the list of faces must be specified), and when choosing, say, 3 people from the list, entering a comment and clicking OK to add 3 new lines. The ID should start with 11 and end with 13 (since our table is full by 10), and the responsible person and comment should already be filled in. So that it remains only to put down the DATES and the status.

Maybe someone met a similar script?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question