How to add some button in Google sheet which automatically reset the values in selected columns as 0

[Sophia Wilson]

I have a google sheet which contains three tabs. In tab one which is 'Sheet1' I have data from column A to O.....I want to add some kind of button which when press it automatically reset the cell value of column E,F and M as 0.

[Darren D'Mello]

Do you have experience in coding? This community might offer help if you have shown the efforts you have made. It looks like you are novice.

Consider hiring a developer.

[Michael O'Shaughnessy]

You could try to record a macro setting all the values to 0 then assign it to a drawing that you insert on the sheet.

Or you could write a quick function that gets the ranges of the columns and sets all the values to 0 then assign that function to a "button" OR add it to a menu...

You have many options... Take a look at this pages to get started:

https://developers.google.com/apps-script/quickstart/fundamentals-codelabs

https://developers.google.com/apps-script/articles/tutorials

On Tue, Aug 4, 2020 at 6:33 AM Darren D'Mello <miscellan...@gmail.com> wrote:

Do you have experience in coding? This community might offer help if you have shown the efforts you have made. It looks like you are novice.

Consider hiring a developer.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAHeo4XhK3Sz_g%2BibpySDAE3oLyq-L7k6LOKf_Om2r_%3D5LWW%3D3A%40mail.gmail.com.