TNW: Google adds Smart Compose to Docs, Sheets, and Slides on Android and iOS. “Google today announced it’s bringing a slew of updates to its Docs, Sheets, and Slides mobile apps — among which is Smart Compose. The apps will also get some minor updates including Dark Mode (yay).”
Google Sheets
TechCrunch: Google Sheets will soon be able to autocomplete data for you
TechCrunch: Google Sheets will soon be able to autocomplete data for you. “Google today announced a couple of updates to Google Sheets that will make building spreadsheets and analyzing data in them a little bit easier. The most interesting feature here, surely, is the upcoming launch of Smart Fill. You can think of it as Smart Compose, the feature that automatically tries to finish your sentences in Gmail, but for spreadsheets. The idea here is that Smart Fill, which will launch later this year, can autocomplete your data for you.”
Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets
Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets. “As with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.”
Alphr: Understanding If /Then Statements In Google Sheets
Alphr: Understanding If /Then Statements In Google Sheets. “If/Then statements are often considered complex. But in reality, they’re not at all difficult to pull off. Plus, they can be more useful than you realize when working with specific data sets or expressions in a spreadsheet.”
Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script
Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script. “You can hide entire rows in Google Sheets manually or use filters to hide any rows that matches the specified criteria. For instance, if you have a sheet containing orders from different countries, you can set up a country filter to hide all rows where the country is not the United States. If you have a Google Script that iterates through each row in the Google Sheet for performing actions on the row, like sending emails or merging documents, you can check for the hidden and filtered rows and easily skip them from the workflow.”
Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File
Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File. “In the past two tutorials on Google Drive API with Python, we have covered how to obtain credentials here and search for a specific file in Google Drive by its name here. In this tutorial, we are going to learn how to download a specific Sheet by name from a Google Spreadsheet into a csv file. A use case for this: you need to generate a report, which data are stored in a Google Spreadsheet that has many Sheets, but you only need one or two of them. So, instead of downloading the whole Google Spreadsheet, you can handpick the Sheets that you need.”
Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets
Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets. “When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form.”
Holy sheet: Even YOU can budget… with Google Sheets (The Next Web)
The Next Web: Holy sheet: Even YOU can budget… with Google Sheets. “There are lots of budgeting spreadsheet templates available on the web. Many of them require quite a bit of work, like filling in all of the specific transactions you conduct. However, that isn’t really necessary for a consistent, personal budget, especially if you have a fairly consistent stream of income and expenses. So we’re here to provide you with an accessible way to budget — a very simple though effective (if you stick to it, of course) template; one that doesn’t require much maintenance, and still gives you a concise glance at what comes in, what goes out, and how much you’re saving per month.”
Holy sheet: How to track your stock portfolio with Google Sheets (The Next Web)
The Next Web: Holy sheet: How to track your stock portfolio with Google Sheets. “Recently, millennials have been bombarded with a slew of new personal finance apps. It seems as if budgeting, saving, and investing is all the rage nowadays, and that everyone’s aiming for FIRE (Financial Independence Retire Early). But again, you don’t really need a fancy app to do all of that.”
Digital Inspiration: How to Send SMS Messages with Google Sheets and your Android Phone
Digital Inspiration: How to Send SMS Messages with Google Sheets and your Android Phone. “There are services, Twilio and Vonage for example, that let you send text messages programmatically to any phone number in the world. You can either build an SMS solution on top of these messaging APIs or you can take a simpler and less expensive route – build your own text sending app with Google Sheets and MIT’s App Inventor.”
Digital Inspiration: Track Coronavirus (COVID-19) Cases in India with Google Sheets
Digital Inspiration: Track Coronavirus (COVID-19) Cases in India with Google Sheets. “The Government of India website has a live dashboard that provides, in near real-time, the number of Coronavirus (COVID-19) cases in various states of India. This is the best resource to get updates around active COVID-19 cases in India. The official website provides the current data but if you were to check how the number of confirmed cases increased in India over time, there’s no historic data available. That’s one reason I built the COVID-19 Tracker with Google Sheets.”
CBR: Forced Google Sheets Migration Leaves Users Fuming Over Broken Services
CBR: Forced Google Sheets Migration Leaves Users Fuming Over Broken Services. “Developers are up in arms over a forced migration to version four of Google Sheets in March 2020, saying the migration breaks numerous functionalities…. A key feature used by programmers in Google Sheets v3 was the ability to run structured queries on Sheets that returned only matching rows.”
How-To Geek: How to Use Sparklines in Google Sheets
How-To Geek: How to Use Sparklines in Google Sheets. “When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always convenient to drop a chart into the mix. To help you, you can create one-cell charts using the SPARKLINE function instead. A sparkline chart is a very small line chart that allows you to quickly visualize your data. It’s useful if you want to quickly see if share price data in a spreadsheet was going up or down, for instance.”
How-To Geek: How to Concatenate Data from Multiple Cells in Google Sheets
How-To Geek: How to Concatenate Data from Multiple Cells in Google Sheets. “In Google Sheets, if you want to link data from multiple cells together, you don’t have to merge them. You can use the CONCAT, CONCATENATE, and JOIN functions to combine them in one cell. These functions range from the simplistic (CONCAT) to the complex (JOIN). CONCATENATE offers the most flexibility, as it allows you to manipulate the linked data with operators and additional content.”
How-To Geek: How to Build Instant Charts with Google Sheets’ Explore Feature
How-To Geek: How to Build Instant Charts with Google Sheets’ Explore Feature. “The Explore feature in Google Sheets helps you gain insight from the data in your spreadsheets with the power of machine learning. Explore automatically analyzes everything in Sheets to make visualizing data easier.”
