Better Sheets - What's the pink text in Apps Script?
Sometimes if you're coding Apps Script, the text turns pink, sometimes gray, sometimes there's a red squiggly line. Find out what those mean in the newest tutorial I just added to Better Sheets today
If you're not a member you can get this video in "Learn to Code in Google Sheets" on Udemy. -Andrew Your Resident Google Sheets Wizard at Better Sheets P.S. The text turning pink is when variables have a capital letter in the front. But mainly they are useful to see the native functions you're adding like UrlFetchApp which connects to API's, and DriveApp, which lets you connect to anything in your Google Drive. The red squiggly line means you have an error. Specifically a syntax error before the red squiggly line. The gray text means you haven't used that variable yet. This is super useful to help debug code. |
Older messages
Free Automated To Do List
Tuesday, August 20, 2024
Made a new freebie this week! Get it now. It's a checklist, todo list, task list.. but automated. Free Automated To Do List Call it whatever you like It's free. Right now It can do this: ✅ Adds
Spreadsheet Summer School registration is still open!
Monday, July 29, 2024
If you have any questions at all, reply to this email! Registration for Spreadsheet Summer School is still open When is Spreadsheet Summer School? Sessions will be 5 PM PST (that's SF/LA time) this
What are Open Office Hours?
Sunday, July 28, 2024
If you have any questions at all, reply to this email! What are Open Office Hours? When is Spreadsheet Summer School? Sessions will be 5 PM PST (that's SF/LA time) this week! I've scheduled 4
Am I ready for Spreadsheet Summer School?
Friday, July 26, 2024
A couple weeks ago I announced I was going to create a Spreadsheet Summer School. This is a live cohort of people like you, who we gather for a few sessions to get you automating your spreadsheets. The
Recreated a Starbucks Order Board in a Google Sheet, in two minutes, and 11 seconds
Monday, July 22, 2024
I did it. I made this in a Google Sheet. Basically I recreated the order status change view of this "kanban" type of board. In one tab you set the name, and the status. In the status column
You Might Also Like
3-2-1: The power of limiting your options, the value of eagerness, and what we undervalue
Thursday, November 21, 2024
3 ideas, 2 quotes, and 1 question to consider this week. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🤯 You Will Be Left Behind (Unless You Learn These 10 Truths)
Thursday, November 21, 2024
PLUS: Live event. Big lessons. Huge prizes (for everyone) 10 Hard Truths You'll Need to Build Wealth Contrarians, Last week, we teased you with the biggest ownership event of the decade — the Main
Ahrefs’ Digest #210: Google manual actions, fake AI profiles, and more
Thursday, November 21, 2024
Welcome to a new edition of the Ahrefs' Digest. Here's our meme of the week: — Quick search marketing news ICYMI, Google is rolling out the November 2024 Core Update. Google quietly introduces
Closes Sunday • Black Fri TO CyberMon Book Promos for Authors
Thursday, November 21, 2024
Book Your Spot Now to Get Seen During the Busiest Shopping Season of the Year! Please enable images to see this email. Black Friday & Cyber
What Motivates Marketers? The Answers Will Shock You 🫢
Thursday, November 21, 2024
We surveyed marketers across the globe - here's what they say. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🧙♂️ NEW 8 Sponsorship Opportunities
Thursday, November 21, 2024
Plus secret research on SoFi, Angara Jewelry, and Dyson ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Literature Lab vol. 1 - Rebecca Makkai | #122
Thursday, November 21, 2024
Fiction: I Have Some Questions for You by Rebecca Makkai ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The Farmer Strikes Back
Thursday, November 21, 2024
(by studying law)
Why Leaders Believe the Product Operating Model Succeeds Where Agile Initiatives Failed
Thursday, November 21, 2024
The psychological, organizational, and strategic reasons behind this seeming contradiction ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
December starts, prepare the 2025 marketing
Thursday, November 21, 2024
We're about a week from December 2024 😮 Did the time fly by for you? I would suggest NOW start planning for how to 2X your 2025. An easy way is to improve the effectiveness of everything in your