Video

Sorry, but some of use are noobs. You didn't tell us how to launch the shortcuts app.

Way helpful thank you!

Thank you! U saved my day. ❤

This was the best app script video I have ever seen!!!

For an extreme novice this video was the most helpful thing I could find! In this example using the apps script, what if you only wanted to copy over the revenue but have it copied to the "Eddie" or "Joseph" sheets based off the name in your master sheet?

I like the way you explained the "1". In other words, return a 1 if all these conditions here are true, or else false. Thank you!

Just wondering, am i able to do the inverse of this? Such as send an email via python automation script with data in the email body to update a cell in the google sheet?

Thanks for the info. Is there a way I can rename files based on cell values on a daily basis? Say, I need to create multiple google worksheets/make copies for like 6 to 10 new google worksheets and rename it based on Column C2:C12 values? Tia!

This is going to help me significantly when it comes to validating data

This is great video. Do you have one where you can match multiple criteria for a result in an array of columns and rows

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"

That's great, it works.. thanks a lot!!

If sort item large and small teacher

Thank you! I really needed exactly this and had no idea how to go about it. This will make life so much easier!

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?

I find this very useful. Thank you for sharing.

Thank you so much ❤

4:30

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 ?

This is great, but I still get Error - Did not find value '1' in MATCH evaluation.

can you set images' file name on download with corresponding cell in the sheet?

Excellent 😊

OMG IT WORKED!!! Thank you! ♥♥

this is brilliant. thank you so much

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?

thanks...more understandable than listening to an indian accent

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.

you're a freaking life-saver!!! A LIFE-SAVER!!!!

Hello! Thank you! It works. However, the images I’ve downloaded are in html format. Can you explain what possibly could be the reason?

This saved us an incredible amount of time. Thank you, Joseph!

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])

perfect, thanks

i see message that function MATCH couldn't find value 1. Any ideas why this happened, recommendations? Will appreciate a lot!

how about 1

Thank you for this!

Hm. I ran the code with no error but am not seeing the menu.

Absolutely perfect presentation with exactly the right amount of information to get started. Thank you!

How to use these between 2 Google sheets.

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?

Great

Thanks. Great Video, Great description.

Thank you, thank you, thank you! You are incredibly helpful!

can u add to downlowd to multiple folders

very good

Amazing, this really helped me 😊 Thank you

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?