jeudi 25 juin 2015

Random Picker in Google Sheet

On Sheet1, Column A:A, I have a long list of items. On Sheet1, Column B:B, I would like to mark if item in A:A has been chosen.

On Sheet2, it will be a picture/ button, when clicked, it will show a random item from Sheet1 A:A, where Sheet1 B:B is empty.

Thereafter Sheet1 B:B will be marked, so that the same item in Sheet1 A:A will not appear again.

Can any expert teach me how this can be written in Google script? Many thanks in advance.




Aucun commentaire:

Enregistrer un commentaire