I tried inserting the code from this StackOverflow question, but I am getting an error message and I am not familiar enough with .gs code to understand what the issue is from the debugger.
Currently I have a basic script that puts the Google sheet name into the cell tat has =sheetname() in it. It is working and it seems to be on some daily refresh because it eventually will update the cell names if I change the sheet name, but I want it to refresh faster/when a change happens. I added an OnChange Trigger as well as copy-pasted the code from the question response above. Is someone able to help me figure out what`s wrong?
Thank you!!!
