I use this group creator spreadsheet several days a week. Huge time saver. https://t.co/12EhQwFE8D #GoogleEdu #teachers #edtech #googlesheets https://t.co/kdOM3StueF
— 𝘑𝘦𝘯 𝘙𝘰𝘣𝘦𝘳𝘵𝘴, NBCT (@JenRoberts1) Nov 22, 2022
Working with dates in the QUERY function can be tricky. 😕 So for today's #GoogleSheets tip, I'm going to show you how to reference dates correctly in the QUERY function. Let's go!
— Ben Collins (@benlcollins) Oct 19, 2022
Add Some Poo ? to Your Spreadsheet https://t.co/pLUSW4kuiJ https://t.co/YWdushKkRr
— Alice Keeler (@alicekeeler) Oct 6, 2022
How to make data from a form printable when you have multiple sections in the form: flatten, query - YouTube https://t.co/6ato7twvut
— Tom Hammerlund (@thammerlund) Sep 3, 2022
How to Create the Ultimate Travel Spreadsheet (and Why You Need One) https://t.co/kS8ZVbnVkV
— Tom Hammerlund (@thammerlund) Aug 28, 2022
How I made Tetris in Google Sheets - YouTube https://t.co/4SpTkHNHSO
— Thomas Hammerlund (@thammerlund) Aug 10, 2022
For this example, we can use this formula with a * wildcard: =COUNTIF(A2:A9,"R*") It counts every instance of a word beginning with R, regardless of what characters follow (also matches a single letter "R"). 👌 https://t.co/WEqwT4MNP7
— Ben Collins (@benlcollins) Aug 9, 2022
How to Make and Share a Household Budget in Google Sheets https://t.co/Nj0wJNmMYO
— Thomas Hammerlund (@thammerlund) Aug 3, 2022
Six tips for better spreadsheets https://t.co/dMwR2aAxdc
— Thomas Hammerlund (@thammerlund) Aug 3, 2022
The top 8 Google Sheets tips and tricks that will make you more productive https://t.co/JpYOUHXqjE
— Thomas Hammerlund (@thammerlund) Aug 2, 2022
As far as I know, you can't access @GoogleWorkspace smart chip values through Apps Script with a built-in method (yet), but here's a clever workaround from Tanaike 👉 https://t.co/CPsKO3FpQP https://t.co/BI2BisXqvm
— Ben Collins (@benlcollins) Aug 2, 2022
Google Sheets - Stock Market - Steady vs Lucky vs Unlucky Investor Comparison Model Template - YouTube https://t.co/3l2N6QMEV8
— Thomas Hammerlund (@thammerlund) Jul 31, 2022
Barcodes are visual representations of numbers. And not just any numbers, but numbers that link back to records in a database storing valuable information about a product. Today I want to show you how easy it is to create them in #GoogleSheets. Ready? Let's go!
— Ben Collins (@benlcollins) Jul 25, 2022
I’m excellent at planning vacations — steal my tips https://t.co/stlux1Z5uX
— Thomas Hammerlund (@thammerlund) Jul 25, 2022
The SWITCH function is a useful tool for categorizing data. It can save you from messy, nested IF statements. It's used to test an expression against a list of cases. It returns a value when the expression is EQUAL to one of the cases.
— Ben Collins (@benlcollins) Jul 18, 2022
How to Create Slides from Google Docs - Teacher Tech https://t.co/B6n7HM1hZ0 #googleSheets#googleEDU https://t.co/MOKlQGPbsx
— Alice Keeler (@alicekeeler) Jul 14, 2022
We're going to use the onion method of building your formula in single steps. More on this method 👇 https://t.co/QLrvSDIHt5
— Ben Collins (@benlcollins) Jul 11, 2022
The speedy way to do this is to use the randomize range feature! Just highlight the data (skipping any headers you might have) and go to Data > Randomize range. This will sort your data in a random order. Couldn't be easier! https://t.co/BaBTpyNwOv
— Ben Collins (@benlcollins) Jul 8, 2022
👋 Happy Monday, everyone! I've got a handy #GoogleSheets tip for you today. Has someone ever shared a Sheet with you that's full of annoying line breaks, like this? Nobody likes multiple lines causing big tall rows like that in a spreadsheet! Here's how to fix that... https://t.co/Yex5ysBs2t
— Ben Collins (@benlcollins) Jul 4, 2022
How to Count Cells With Text in Google Sheets https://t.co/9ZpHLyAXAa
— Thomas Hammerlund (@thammerlund) Jun 25, 2022
