I'd like to do a simple calculation every time a new sheet is uploaded to a folder in Google Sheets. The calculation should be automated so the script will recognize a new file and will go to a specific column in it and add 10% of that cell value to the same cell.

  • 1
    There is no trigger for "a new spreadsheet was created in a folder". What you can do is run a timed trigger, perhaps once an hour, that will loop over all spreadsheets in a folder and perform the calculation. – user79865 Jul 3 '16 at 3:34

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.