In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.
welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.
Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".
Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!
Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Free min game to learn 3 keyboard shortcuts, get it at https://kampheyapproved.gumroad.com/l/escapespreadsheethell