I currently have a working function that uses the onOpen() trigger to run. I am needing to make this an on edit instead of onOpen function so that a when a change is made in my master sheet, the child sheets get updated with the new information.
I need the child sheet to run the function as soon as any data is entered into the master sheet column a. I know after reading similar questions that I need to make an event trigger, however, I am not sure how this is done. I have gone into the "resources" tab and attempted to set an onEdit trigger, but it seems like if the current spreadsheet is edited then the function will be ran. If I need it to run when the master sheet is edited, should I move the script to that sheet?