google script

Hello! I am trying to find a way to delete certain cells based off a check box in another. For example if H3 (which has a checkbox) is marked as true, then I would like B3,C3,E3,F3,G3, and I3 to have their contents cleared. Is this possible with a formula or script? I have attached a photo...

I have a simple "App" in google sheet when they press button it runs random number, then i want to store time and the value what they got in second sheet, as a log what happend. I am new with scripting and i cannot find anywhere how to write to columns data from script. Currently it only writes...

Good afternoon, I have this code that copies to sheet "INVOICE_ENTRY" any row in the range A5:P if it finds a value in column N. "INVOICE_ENTRY" sheet is identical to the srcSheet, except it has a couple more columns after P. What I want to happen is after running the script, if it finds a...

I know this may be a large ask and may not be possible but I am new to VBA and never really used sheets before in a very elaborate fashion. I didn't realize that the excel sheet with vba wouldn't translate to sheets so I need to convert my vba code to google script so that it will work in...

I need a google sheet to have the same functionality that my excel workbook has but the code doesn't work on google sheets. there are 4 columns (Date, Location, Location, Location) when a value is updated in a location column I need the date cell in that row to update with the current date...