I have two separate google sheets (GlobalReport & IndividualReport). Both share information between each-other, but I need to be able to "reset" a cell value in the IndividualReport sheet.
Cell L7 on the IndividualReport sheet is validated (see screenshot) from a range of values form another sheet within the workbook. There are four options to choose from (one is 'no'). I need to be able to "reset" that value to 'No' at random times from the GlobalReport sheet.
I'm currently using
=importrange("1Cm0tAGlobalReportSheet", "lists!A1:A30") to populate the validation list.
Is possible to update IndividualReport L7 using some kind of trigger? If yes, any help would be greatly appreciate.