dimanche 1 septembre 2019

How can you make the checkbox in Google Spreadsheet sort specific data? Is the script function necessary?

I would like to know if there is a way to sort some data based on the checkbox in Google Spreadsheet. Is there any specific function which can sort based on if statement or script needs to be created?

How the spreadsheet looks

Each group has a Group Done and checkbox for it below it. Idea is to once you press the checkbox, it would sort out the group based on P (Position). Not sure exactly how to create it.

If script is needed I was already doing once automatic sorting with onEdit() function, but it weas simple one for just one table or one set of Data. Is it possible to do it based on reference value of the TRUE statement in the sheet and if it finds it, create the box of values from that position and sort it out?

Thank you for any help.




Aucun commentaire:

Enregistrer un commentaire