How-To Geek: 13 Google Sheets Date and Time Functions You Need to Know. “When you use a spreadsheet for things where the timing is essential, you likely include dates and times. Google Sheets offers a collection of functions for formatting, converting, and calculating dates and times to help with your data entry.”
Digital Inspiration: Formulas in Google Sheets Disappear When New Rows Are Added – The Solution. “The formulas in Google Sheets may get deleted when new rows are added in the sheet or when new responses come in through Google Forms. The fix is simple!”
How-To Geek: How to Import Data With Google Sheets Functions. “You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet. With the functions we’ll describe here, you can pull data into your sheet from external sources. Then, analyze, manipulate, format, and do what you please with your new data.”
MakeUseOf: How to Build a Simple and Effective Content Calendar in Google Sheets. “With many content calendar software available, it can be challenging to pick one. Some are overcomplicated, some are outside your budget, and others give you a suite of tools you’ll never use. It may even be that you’re still trying to pick your favorite and need a solution in the meantime—one without a paywall or trial period. Whatever the situation, you can create one that offers what you need—and nothing more—using spreadsheet software.”
9to5 Google: Google Sheets adds XLOOKUP, Named Functions, and a few other advanced features. “Ben Collins, a Google Developer Expert working with Sheets, shared this week an explanation detailing several new features that have been released for Google Sheets. Specifically, 10 new functions that will be helpful for power users.”
MakeUseOf: How to Transpose Data in Google Sheets . “Have you got a table in Google Sheets that’s in the wrong direction? Whether you want to turn a vertical table horizontal, or the other way around, transposing is your best friend.”
How-To Geek: 6 Effective Ways to Use Explore in Google Sheets. “The Explore feature works differently in Google Sheets than in Google Docs. You can use it to get useful details about your data to help you analyze it. You can also use pieces that the tool provides in your spreadsheet. If you’re looking for a handy way to learn more about the data in your Google Sheet, here are various ways to use the Explore feature.”
Chrome Unboxed: Google Docs, Sheets, and Slides will now warn you of Office file compatibility issues
Chrome Unboxed: Google Docs, Sheets, and Slides will now warn you of Office file compatibility issues. “First and foremost, a new warning indicator will appear if your file has compatibility issues in Drive. It will appear and stay for the entirety of your editing session or so long as there are problems to be certain you address them before shipping the document off to its recipient.”
Digital Inspiration: How to Calculate the Percentage Score in a Google Forms Quiz. “When someone takes the quiz and submits the form, the responses are recorded in a Google Sheet that is set as the response destination for your Google Form. There’s something interesting here as well. If the associated form is a quiz, Google Sheets will automatically add an extra column in the response sheet titled ‘Score’ and this column will be populated with the total marks obtained by respondent in the quiz.”
TechCrunch: Google is adding new Drive, Docs, Sheets, Slides and Keep optimizations for tablets. “Google introduced Android 12L earlier this year to make tablets easier to use, and at I/O, the company announced plans to update more than 20 Google apps on tablets to optimize them for larger screens. Today, Google said it’s adding several new features for Drive, Docs, Sheets, Slides and Keep to get started on this promise.”
Search Engine Land: 11 Google Sheets formulas SEOs should know. “While it’s not great at plotting ranking data (inverting the y-axis is always ugly), there are numerous ways to use Google Sheets for SEO. Here are 11 of the formulas and tips I find myself using for SEO on an almost daily basis – for keyword management, internationalization, content/URL management and dashboards.” Just ignore the SEO part. This is an excellent roundup of Google Sheets functions with quick, digestible examples.
MakeUseOf: How to Find Public Google Docs (and Slides, Forms, Sheets, and Drawings too). “Similarly, you can easily find public Google Docs, Slides, Forms, Drawings, and Sheets using some easy but Advanced Search operations and tools. In this article, we’ll show you some simple tricks to help you find public Google Drive files including Slides, Forms, Sheets, and Drawings.” Joy Okumoko does it again. I didn’t know about Heystack.
Digital Inspiration: How to Auto Format Google Form Responses in Google Sheets. “Learn how to automatically preserve the formatting in Google Sheet when new Google Form responses are submitted.”
Digital Inspiration: How to Send WhatsApp Messages from Google Sheets using the WhatsApp API. “This tutorial describes how you can use the new WhatsApp API with Google Apps Script to send WhatsApp messages from Google Sheets. The same approach would also work for sending WhatsApp messages from Google Forms when new form submissions are received.”
Digital Inspiration: How to Auto-Download Podcasts to Google Drive with Google Sheets. “This tutorial describes how you can use Google Sheets to build your own podcast manager. You can specify a list of your favorite podcast shows in Google Sheets and it will automatically download new episodes to your Google Drive in neatly organized folders. The setup is very simple, the app is completely open-source and you need no programming language.”