Good day, I was wondering if its possible to upload a file (pdf / img) to a specific folder created ex. Stranger Things -> at column 7 instead of just description you upload a photo/pdf instead a document and it'll save or upload that file to the Stranger Things Folder?
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit"
This is perfect. Thank you! I do have another question about using url images but with google slides. Can I create a new slide per row of data and save the images from the url to a slide image placeholder (using the same shape as the placeholder, meaning circle or some mask). Is this doable?
This is exactly what I need, but unfortunately I'm limited to Excel 2016. Is there anyway to accomplish the same effect without the use of XLOOKUP?? For example, with VLOOKUP or another approach? Thanks in advance!
this is a great video ! thank you! Can you help me with this: how to I automate the sheet so that if within a row, a column dropdown is marked "Yes". the entire row gets moved to a different sheet within the spreadsheet ?
is it possible in a query to grab from a row instead, and can that row be a variable that is named when a sheet is generated by a template? in other words, can i put the query in the template?
I'd love to be able to rename the downloaded image files based on data in another column - to expand on your example, rename them as partnumber_01, partnumber_02... .jpg/png etc.
Does anyone know where this feature is explained / documented ? I would really like to understand why placing a "1" in "search_key" parameter of the MATCH function makes it behave this way ... Here is the syntax from google help: MATCH(search_key, range, [search_type])
This is awesome. I would love to get a little help in getting mine to work. Is there any help available? One of my issues is a message. Don't have permission to run.
I love the sheet and I appreciate all the work. But I get the error: "TypeError: Cannot read properties of undefined (reading 'range') onEdit @ Code.gs:81" This happens both when I type the code myself and when I copy/paste from your linked code. Can you see the problem?
Im struggling to find it. I can automate in excel but im wanting to share it in Google drive and excel sheets doesnt have it and i suspect thats why it doesnt work from there
Very helpful. Thankyou 1 question. What if i want to add attachment (pdf / image) based on link that state on the google sheet instead of document description? what script do i need to change?
If I have a colleague that triggers the edit, therefore they would be the active user, is there a way for the email to come from the active user instead of me? Or is it set that it will only be sent from the person who created the script?
Thank you for the Knowledge, suggestions to put more videos based on excel sorting techniques, and index is powerful, and the best way to sort data on criteria, sorry Vlookup and XLookup you guys are interesting but index is surprising, if and only if know how to use it to the requirement; Great Job Sir. Regards.
Hi Joseph, I am a big fan of Excel and this trick has helped me many times, only can you also do an index lookup over different sheets. I am stuggeling using an xlookup when I need results matching 2 criteria.