dimanche 25 octobre 2020

Adding a Checkbox to each Pivot Table Row in Google Sheets

Does anyone know how to automatically add a checkbox to the beginning of each result row in a pivot table in Google Sheets?

On this Google page: https://support.google.com/a/users/answer/9308622?hl=en, it seems to say that it is possible, but doesn't say how to:

  • "Use checkboxes to make Google Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas."

I would like to allow the user to select one or more rows from the pivot table result, and then have a script run over the rows, doing something with each selected (checked) row.

You could add a checkbox beside the pivot table in a huge number of rows (so there would be a checkbox no matter how long the pivot table is), then allow the pivot table to fill in beside each of these checkboxes, but that would be a brute force approach and look bad.




Aucun commentaire:

Enregistrer un commentaire