How can I use JavaScript in Google Sheets?

In Google Sheets, we can use Apps Script (JavaScript) to create custom functions. In this video we show how we can use just a bit of code to create a custom function that gives us more control and ability to create more complex functions.

[MellolaMason]

this was my first one where I got them all... 10 outta 10 will recommend

[JHatLpool]

Good demonstration of basic, core principles.
Google sheets is marvellous. Look at what a user can do and he doesn't even need his own PC/ laptop !

[hfhacksflyhigh]

Very well explained, i thought it was at too basic a level for myself once i got the general idea, but I watched til the end.

[charlyk]

thanks, can you explain if possible how to add something in every new comming line in sheet, as i write 33 in one line and it automatically add 1 in previous line and write result in new cell. thanks if you can help.

[mengzhu]

Thanks for posting such an amazing and easy-to-follow tutorial!

[christianbatchlor]

I need some help, my function won't show on the actual spreadsheet. Thanks so much for the helpful video.

[MellolaMason]

yep I needed that knee to the boys... good job Sr. Great vid loved it

[jackgnibus]

Very helpful! My program is working now! Thanks so much!!!!

[TheQAAA]

Very good job, can you help I would like to store a historical data of the pulling info that contain the data and time of fetching ?...thanks

[JC-ooix]

Python also has a shortcut akin to i++.

It's: i + = 1

[jailbirdxx]

Can APIs also be manipulated in GSheets?

[reginabegum]

Very understandable. I have one question. I want to fetch live data from a website and refresh the data in sheets every one minute. I used importHtml to import data but when i use settimeout method of javascript to refresh, it shows undefined. Could you please help me how to do it ?

[abdullahquhtani]

Is there any way to make a script with html the search data from spreadsheets and display result in HTML?

[KINGKHAN]

Hi Timothy,
Thanks for Posting Nice Video, I have got question regarding downloading current google sheet to my local computer drive.
Do you have an idea how can I download the current Active Sheet using google Script or Java Script without user intervention.?

[sanjaysingh-mdcx]

sir, can you please a video on Java abbreviations and little explanation of that

[TheOligopeptide]

Hello,
What would the script (syntax) be if I would like to subtract two cells sitting next to each other...say columns B3 and C3.(the entire column)I do not want to use the built in function from google sheets just to create a new subtract function.
Thanks!

[OscarRodriguez-jbgo]

Hi Timothy i try to execute the command

function MYO(values) {
return values.length;
}
but always give me the same error message

TypeError: Cannot read property "length" from undefined. (line 5, file "Code")

What's the problem???
Thanks

[qbantreefrog]

I keep on getting MYSUM() as 0 but i made sure that the script was written exactly as it was shown. What am i doing wrong?

[chuan]

I dun get it i type exactly same as you
and I kept getting this
TypeError: Cannot read property "length" from undefined. (line 5, file "Code")
Can you help me ?

[kirankkiirraann]

Hi timothy, i wanna know how to stop responses of spreadsheet forms for a particular period of time(i.e, 3 it possible???