2

Trying to automate find and replace function on form submission within sheets.
Principal/Teacher submits a photo through a Google Form and I want to change from the file link to a search to link within the Google Sheet. Currently have to manually do this and would like to automate the process.

Here are the find and replace codes currently using find

https://drive.google.com/open?id=

and replacing with

https://drive.google.com/uc?export=view&id=
1
1

You would need to use a formula with the SUBSTITUTE function

=SUBSTITUTE(D8,"https://drive.google.com/open?id=", 
               "https://drive.google.com/uc?export=view&id=")

enter image description here

1
  • That would work, I am just wanting to have it automatically change when a form is submitted. Is this even possible? – Ryan Weaver Jan 26 at 21:52

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.