Welcome back

Can you please shar the google sheet for us to practice along?

Can you please shar the google sheet for us to practice along?

Can you please shar the google sheet for us to practice along?

I had long calculations repeated 2 times, which is annoying. This will take care of it for sure. Can you use LET in Pivoit Table's calculated field?

On line 23 he wrote tempFolder.removeFile(tempFile); but as of 7/16/24 removeFile() has been deprecated, but I was able to achieve the same result with the following: tempFile.setTrashed(true)

Excellent video. Thanks

Great channel backs. Get __it Done! will return too?

Sensational explanation! We miss these videos. Very good!

May I know where to get the google sheets for me to practice along?

Where can I find the google sheet so that I can follow along with you?

Great

Const recordsFound = data.filter(r => r[5] == searchValue) Came in error😅😢

Nice video. Thanks for uploading this. Is it possible to send the link to the google spread sheet, you used here ? so that people can follow your instructions while watching the video

Thanks for the video. But regarding the table creation itself not the pivot table, is there a way to create the table without the row height changing? I find it cringe and unorganized when the row height increases. especially when you made the table here and it increased the row height for the first part of the table, but not for the last part.

thank you so much!!!!!

Thank you so much for showing me how to do this. I used the Find And Replace method. Woohoo!

At 30 mins, after selecting DDL1, the DDL2 output to inline rather than array list. Your help is highly appreciated function onEdit(e){ var activecell = e.range; var cellval = activecell.getValue(); var rowval = activecell.getRow(); var colval = activecell.getColumn(); var wsname = activecell.getSheet().getName(); if(wsname == "BEP" && colval === 1 && rowval > 1) { var filteredrange = dsdata.filter(function(o) {return o[0] === cellval} ); var applytoddl2 = filteredrange.map(function(o) {return o[1]} ); var cell = ws.getRange(rowval,2); applyValidationToCell(applytoddl2,cell) }

Very helpful. Thank you very much

Wow, thanks for clarifying about this.

Thank you for sharing this amazing content. Does this work with multiple users accessing the sheet sir?

Perfect vid

Thanks for this very good video and welcome back ! Take care when using array formula inside a table. If you sort the table by a column, the results may be strange or wrong.

please explain how to make photos visible in a google form pdf

There is no macro in the excel file

please share data so that we can practice. excellent video.

I tried this formula on a table with Dates in header. Value error occurred, if I set field to any column where header is Date. This works fine if the header is text. I tried converting Date into plain number as well. Is there any work around to this done. It's important. Will appreciate your help.

4:44 Hyperlink Formula (Table) 6:00

I get a list of orders by different doctors each day. I want to take that data and start a running total by each doctor. My goal is to trach how many orders we get by each doctor. For example the doctor X for the month of July sent over 6 , Doctor Y 10. How can I do that ?

Amazing video - Simple and easy to follow your instructions for a complex action! Thank you so much!!!

Hi Thank you so much for all the tutorials and it is very helpful. can you please add CRUD tutorial for office script?

Excellent intro!

I tried it today. It works if your data is not in a table but if it is in a table then CHOOSE Function didn't work for me. Have you tried it with tables? Thanks

Nice, thanks! How would you do if the other report from where we are getting the columns had some filters on those columns which you want to bring to another sheet? Do you have any videos of that? Thanks

I can't say enough about your channel. Thank you so much for your content

Thank you very much ❤❤🎉 this really really helps a lot... But I'm facing some struggle.. I've made the conditional formatting to the first day and the cell under it, as you have explained, BUT when I go copy and paste that to all the rest I get them allll at that color.. instead of only for the days aren't included at the month...😅😢 how can I solve that.. Bear in mind I do special paste& format only .. I don't know why..

Thank YOu , NIce work

Hi. Great content. Is it possible to make the Webapp work offline?

I found very anoying to write =sum every time. In excel just clicked the sigma and that was it. Here if the sigma isn´t taking the cells you want, if you click on the cells you do want, the function goes away. Is so upsetting

Nice, thanks! It was nice to see how to get any number of columns and they don't have to be side by side. Please always upload a Sample file so that we can practice with you.Thanks

This video is really helpful.please can you help me see my explore in my google sheet

Can you post some videos using the Gemini API?

When I try to use these codes, they show Code:4 when const ws = ss.getSheetByName. They are not letting me execute the script. Can you please help me with this?

You are the best on Explanation. I want to work with you every day.

You don't know how much time you save me. Thank you so much!

@30:33 You discuss how the pivot table doesn't update to added rows. Now that GSheets has Tables, if your source data is in a table, will pivot tables update with new rows automatically?

Its not working with App version, you are showing this formula in web version, do you have any formula for app version?

very helpful. thank you boss

Can you share this data so we can practice. Please!🙏

Thank you! You are really joss...🥰