Google Forms - Formulas in Sheets That Autofill with Submit

Thank you for the technique!....

you should try =query(Main!A:I).... in a1 in new sheet. this is easy . (in case i have rename my response sheet name into "Main"

A Brilliant tutorial. I learned a lot from it. I need to know how can I change the formula when the preces changes every month. Eg: January price is 100 and February Price is 125. So I want to multifil the quantities bought in January with the 100 and February quantities with price 125 . Kindly educate me how to do it. Thanks

thanks dude

I tried the formula but an error occurred: Error
Array result was not expanded because it would overwrite data in F4.

This just changed my life ! Thank you !

Thanks!

Great tutorial! I especially appreciated the teaching structure of starting with simple examples and building up to more complex and efficient ways to implement the autofill functionality.

This is great, thankyou.

Thanks Great video i just to know how to use concatenate and =googletrasnlate function in it please help me in this regard.

Always learning great new things from you, keep up the good work. Trying to find a video on tabulating checkbox data from a form. For some reason up until now I never had to do it or realize how difficult it is

Thank you . Just thank you.

🔥🔥🔥 What a cool video and easy tips. Thanks for your efforts they are most appreciated. SUBSCRIBED! .... do you have a way where different departments update the same google form but relative to their section. For example the service reception logs in customer data and job number and the technicians log their respective job start and end times to that same job number? .... or would it be having separate forms to one Google sheets file and then creating the "My Calculations" Tab to arrange all data? Thanks !

Well done! Thank you very much!

Great video, exactly covering the problem I'm looking to solve. And the first tutor that does not use copy&paste when reusing 90% to 100% of his already written formulas at least 3 times. 😀

Customers should know the prices and the total before they buy. Can you show the total in the form also ?

Great Tutorial. Got me so much farther than others. Greatly appreciate it.
only thing is that whenever i submit an form it actually "pushes" the formula cell down and doesnt use it (cell stay blank). I should mention that I am using this form to populate the excel sheet but then creates a document from the cell fields. I can share a screenshot and also have the script code if that helps.
Cheers

I have not seen any Goole forms tutorial this deep ...awesome!!

Thanks for this video! Is there another tutorial which Google Forms shows the price of the product you selected previously?

very helpfully. Thank you

Dear Sir, I want to create a pdf and semd email after submitting google form with the addtional data. I followed your all videos and i want to add addtional column in pdf doc and send email.
It is can possible can i connect another formulas column in that procesa?

Please help. 🙏🏼

How do I do this every other line, so I use the google forms as a clock in and out system, and I want to automatically calculate the difference in in time between the first timestamp and the second timestamp.

This - is a perfect tutorial. (1) it was exactly what I wanted. (2) You built it from scratch. (3) You showed the process of starting simple and adding complexity/simplicity where needed.
Here, have a like and a subscribe from me.

Thanks, this is really helpful!!

Wow thank you...

Very useful tutorial. Thanks a lot!

query function works perfectly fine without combining so many confusing formulas

This video resolved my problem. I subscribed, liked and would like to say thank you!

Thank you it worked and I learned some good stuff here

Very nice video! Congratulations!

I'm trying to generate a report after the form submission and I'm getting the calculated columns as "blanks".

For example, I have a Form with 2 questions, Client and Price.
var timestamp = e.values[0];
var client = e.values[1];
var price = e.values[2];

So, I've created a new calculated column (with array formula) which is Price*(any number).

When I try to collect this new value in the variable "var total = e.values[3];", I get a blank value...

Do you know why? Is there a delay?

Thank you so much, have been sutck on this problem for almost an hour!!

When you create My Calculations sheet, are you then able to sort it manyally using filter? Or the data is in the exact order as they are entered in the form?

I can't like this video enough. Thank you so much for doing it

Can you please help me with this for the same situation ?
=(((BM2*4)+(BN2*3)+(BO2*2)+(BP2*1))*10)/((SUM(BM2:BP2)*4))

How to use Count if function in the same situation ?
Currently, the formula is =(COUNTIF(I2:BH2,"*Critical*"))

This Video is one of the most USEFUL Videos I have seen you do. What I like most about your Videos is in each Video you are throwing in a lot of Tips and Tricks that I don't see in other Videos. Thanks!

tq so much!

array formula didn't work with OR functions. How to solve this problem ?

Thanks. This video just changed my life.

Another great video. Can you reorder the entries so that the new orders are at the top of the spreadsheet?

Thank you so much. I needed this array function to complete my sheet!

Thank you so much, I looked for this function for few weeks and I finally found at here! Thank you so much, and I hope you can keep make more useful videos!

Content was very good however font size is too small

I have to pull data from branch and day wise and it's cumulative in other column...say in A column sales per day and in other column job cards per day I have to pull these data and show it day wise and its cumulative in other column...any solution will save our time greatly appreciable

Very very helpful ! Thank you very much !

Génial !! Formidable !!! MERCI BEAUCOUP :-)

Amazing! Master of your skill.. it's nice to see multiple options for completing the same task and which methods you prefer over others.

I have seen lots of help videos on Google Sheets. You are the best at explaining Sheets!!!! You are very easy to follow along with and explain things very well. Thank you very much and keep it up!!

Thank you so much for this video! I spent hours looking for this answer. Truly appreciated. Thanks for taking it step by step and showing us common mistakes.

Thank you so much for this!