Видео

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?

GOOD VIDEO

Thank you.. helpful.. is it possible to reach out to you to get your help with a script I have been struggling with for a few days now?

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?

Great video Joseph. Thank you so much. Very clear instructions and logic. Thanks!

Great video! Thank you!

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.

Brilliant work, thanks!

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.

thank you bro .....

That's really helpful formula I'm looking for!!! Thanks much ❤

how do I add the Automation tab in my Google Sheets please?

HOW WOULD YOU IMPORT AN IMAGE FROM ONE SHEET TO ANOTHER? I ADDED AN IMAGE FROM MY GALLERY TO A CELL AND I LIKE TO IMPORT THAT IMAGE (FROM THAT CELL) IN TO ANOTHER SHEET. 😊

Thank you for this. This example make easier to move data

thanks

This is exactly what I needed. This is gunna make my dev work so much easier. Thank you!

Thank you sir! I need to add a script that i want. i would like to see shared google drive urls in the third columbs for each downloaded images. can you describe?