This was the best app script video I have ever seen!!!
@rosiepost93704 күн бұрын
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?
@mirosDV11 күн бұрын
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!
@t02fy4tc0sx12 күн бұрын
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?
@josephjasperamparo308017 күн бұрын
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!
@carloscastaneda704722 күн бұрын
This is going to help me significantly when it comes to validating data
@johnstath966627 күн бұрын
This is great video. Do you have one where you can match multiple criteria for a result in an array of columns and rows
@japhenriquez140Ай бұрын
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?
@romanrocks572Ай бұрын
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"
@dariodipaola8156Ай бұрын
That's great, it works.. thanks a lot!!
@lythienghuo2876Ай бұрын
If sort item large and small teacher
@Elizabeth-ei7neАй бұрын
Thank you! I really needed exactly this and had no idea how to go about it. This will make life so much easier!
@pikeswayАй бұрын
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?
@FranulkarNagieАй бұрын
I find this very useful. Thank you for sharing.
@abhishekkuradia898Ай бұрын
Thank you so much ❤
@Chanderv31Ай бұрын
4:30
@abernier14012 ай бұрын
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!
@CheyanneKabia2 ай бұрын
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 ?
@bit_Jon_Trader2 ай бұрын
This is great, but I still get Error - Did not find value '1' in MATCH evaluation.
@JonDellosa2 ай бұрын
can you set images' file name on download with corresponding cell in the sheet?
@ekelly8582 ай бұрын
Excellent 😊
@MK-jn9uu2 ай бұрын
OMG IT WORKED!!! Thank you! ♥♥
@kMyAbdulrahman3 ай бұрын
this is brilliant. thank you so much
@emilytischer51773 ай бұрын
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?
@flightforge303 ай бұрын
thanks...more understandable than listening to an indian accent
@nikhammarberg3 ай бұрын
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.
@kishoarwasifchowdhury48393 ай бұрын
you're a freaking life-saver!!! A LIFE-SAVER!!!!
@lahnahar3 ай бұрын
Hello! Thank you! It works. However, the images I’ve downloaded are in html format. Can you explain what possibly could be the reason?
@afcopg42853 ай бұрын
This saved us an incredible amount of time. Thank you, Joseph!
@timrapoza59853 ай бұрын
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])
@GP-ue5hd3 ай бұрын
perfect, thanks
@user-op6ul3yj6z3 ай бұрын
i see message that function MATCH couldn't find value 1. Any ideas why this happened, recommendations? Will appreciate a lot!
@Ersys-ck6zl3 ай бұрын
how about 1
@DanielChacon-uk9qm3 ай бұрын
Thank you for this!
@dionakidd74994 ай бұрын
Hm. I ran the code with no error but am not seeing the menu.
@medthehatta4 ай бұрын
Absolutely perfect presentation with exactly the right amount of information to get started. Thank you!
@RajKumar-hv8kq4 ай бұрын
How to use these between 2 Google sheets.
@alicenigl58624 ай бұрын
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.
@hammockmonk4 ай бұрын
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?
@asmrindia4 ай бұрын
Great
@richardwhalen18594 ай бұрын
Thanks. Great Video, Great description.
@OndosSaragih4 ай бұрын
Thank you, thank you, thank you! You are incredibly helpful!
@danielmachuca65074 ай бұрын
can u add to downlowd to multiple folders
@danielmachuca65074 ай бұрын
i have the column A with some codes and need to download the pictures into the folder with the code name
@abdalbastsalm58014 ай бұрын
very good
@angelodelmindo98084 ай бұрын
Amazing, this really helped me 😊 Thank you
@alanharris30615 ай бұрын
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
@user-dz3jx3nr9g5 ай бұрын
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?