Hi, I've found your videos helpful. Would you be willing to include copies of your workbooks? I have to scrub the videos to see the exact syntax being used when I have problem areas.
Hey! Can you do a video about an other techic to store data and manage with spreadsheet? Once i saw a program like that. I think the data was in a database and the other management were in the spreadsheet.
Hi, thank you for your videos. Your channel has helped me understand the google sheets. Could please direct me to the data sheet which I can download to follow through in this video
1. How do you pull information from another document sheet to anther document sheet. Like in the google browser tabs totally two different sheets to have to separate sheets not in the lower tabs on the bottom to make a master sheet document. 2. Within the document how do you have multiple sheets to make a master graphic chart not master sheet. Do I have to make a master sheet to mix blend the others sheets to make the master graphic chart?
I was wondering if you could help me with something. I followed the guide to your video Google Forms - Email Notification Script - Send Confirmation Emails to Users to configure confirmation emails. I was wondering if you know a way that I can include what the respondent answered in the confirmation email? Please answer ASAP or when you get a chance please and thank you
Learn Google Spreadsheets Do I copy and paste the code and put it under the function to send the email or do I have to create another function. I was also wondering where do I get the Google Form ID from?
@@ExcelGoogleSheets I applied the code and I was wondering where do I get the Google Form ID from? With the code, should I add it to the one that sends the email or should I just create a new script and set up a trigger for the response to show in the email? Or is there a way to code it into the HTML? Thank you, you've really been a great help to me.
Thanks for your video :) I have a question. I’d like to make my scheduler on google sheets and send it to people living in different timezones. If i want them to see my schedule in their timezones, what would I need to do for that?
Please help me how can i set the threshold level for best results. I mean it should be automated. In my case i have data with 28 lakh (2.8 million) rows and its not possible to check the data row by row. Can you help me with this?
There is really no answer to this. When you work with bulk data you just set to something and try to spot check your results and see how it looks overall. You'll have to accept that whatever you choose is not going to be perfect.
Hi, I want to auto-lock Google Sheets cells after the first entry is made. How I can write this code in Google App Script? Can please help me with this?
Hello, i'm really like your content. Thats very usefull for my data. Would you like to help me? I have a lots of data and its in the vertical format, I have coloumn date, criteria1, criteria2, criteria3, every criteria have a value and i want to import that into horizontal in another sheet. But i want to keep the date copy in every criteria. Like this 1/1/20 criteria1 5000 1/1/20 criteria2 100 1/1/20 criteria3 400 I'm very strugle because tranpouse can't copy the date as i want. Please can you help me. Thank you
In Excel you can use Power Query unpivot to do this ruclips.net/video/F0zNs-cyGqA/видео.html . If you are in Google Sheets I'm afraid you'll need a script. It might work with formulas depending on your data but it's impossible to tell like this.
Hi, I've found your videos helpful. Would you be willing to include copies of your workbooks? I have to scrub the videos to see the exact syntax being used when I have problem areas.
Hey!
Can you do a video about an other techic to store data and manage with spreadsheet? Once i saw a program like that. I think the data was in a database and the other management were in the spreadsheet.
I am getting a zero division error for threshold, how to fix it?
Hi, thank you for your videos. Your channel has helped me understand the google sheets. Could please direct me to the data sheet which I can download to follow through in this video
Thank you!
Thanks for watching!
Thanks!
Thanks sir,
Thank You!
1. How do you pull information from another document sheet to anther document sheet. Like in the google browser tabs totally two different sheets to have to separate sheets not in the lower tabs on the bottom to make a master sheet document.
2. Within the document how do you have multiple sheets to make a master graphic chart not master sheet. Do I have to make a master sheet to mix blend the others sheets to make the master graphic chart?
I was wondering if you could help me with something. I followed the guide to your video Google Forms - Email Notification Script - Send Confirmation Emails to Users to configure confirmation emails. I was wondering if you know a way that I can include what the respondent answered in the confirmation email? Please answer ASAP or when you get a chance please and thank you
Use .getResponses() method.
developers.google.com/apps-script/reference/forms/form-response
Learn Google Spreadsheets Do I copy and paste the code and put it under the function to send the email or do I have to create another function. I was also wondering where do I get the Google Form ID from?
@@ExcelGoogleSheets I applied the code and I was wondering where do I get the Google Form ID from? With the code, should I add it to the one that sends the email or should I just create a new script and set up a trigger for the response to show in the email? Or is there a way to code it into the HTML? Thank you, you've really been a great help to me.
Thanks for your video :) I have a question. I’d like to make my scheduler on google sheets and send it to people living in different timezones. If i want them to see my schedule in their timezones, what would I need to do for that?
Use google Calendar and it will be easy
Hi, can u please suggest a video where I can find vlookup like function or alternative to vlookup in app scripts
You'll need to learn how to work with arrays. You pretty much need to ace this entire playlist ruclips.net/p/PLv9Pf9aNgemvD9NFa86_udt-NWh37efmD
Please help me how can i set the threshold level for best results. I mean it should be automated.
In my case i have data with 28 lakh (2.8 million) rows and its not possible to check the data row by row.
Can you help me with this?
There is really no answer to this. When you work with bulk data you just set to something and try to spot check your results and see how it looks overall. You'll have to accept that whatever you choose is not going to be perfect.
Hi, I want to auto-lock Google Sheets cells after the first entry is made. How I can write this code in Google App Script? Can please help me with this?
Depends on who makes the entry.
how is dfNamesMappingTable is a data frame? you didn't write pd.DataFrame()
The function returns a dataframe, so no need for pd.DataFrame()
@@ExcelGoogleSheets how dfNamesMappingTable is a function .. i don't understand?
@@mohamed.montaser .fuzzy_merge( is a function that returns a dataframe
@@ExcelGoogleSheets so the variable "matches" that contain the fuzzy_merge is the data frame
what does the threshold = 0.9 mean?
90% match or higher.
Hello, i'm really like your content. Thats very usefull for my data.
Would you like to help me?
I have a lots of data and its in the vertical format, I have coloumn date, criteria1, criteria2, criteria3, every criteria have a value and i want to import that into horizontal in another sheet. But i want to keep the date copy in every criteria. Like this
1/1/20 criteria1 5000
1/1/20 criteria2 100
1/1/20 criteria3 400
I'm very strugle because tranpouse can't copy the date as i want.
Please can you help me.
Thank you
In Excel you can use Power Query unpivot to do this ruclips.net/video/F0zNs-cyGqA/видео.html .
If you are in Google Sheets I'm afraid you'll need a script. It might work with formulas depending on your data but it's impossible to tell like this.
Depending on your circumstances this script may work for you ruclips.net/video/ea7jjOHHiOw/видео.html
@@ExcelGoogleSheets thank you so much, its help me a lots.😍