I need to change all the text in a google sheets to upper case, the problem is it's filled in by Zapier which doesn't register as an edit for onEdit functions. It's also automatically converted to .xlsx and emailed so none of the add-ons will work because they need to be manually ran. After the email sends a script wipes it and we start over as a daily report. I've looked everywhere for a script that will work but haven't been able to find anything. I currently have it transferring to another sheets using importrange wrapped in arrayformula(upper, which works but then my xlsx cell contents is all iferror functions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.