Tutorials about Google's G Suite from THE Journal

Interested in contributing?

Contact David Nagel at [email protected].


How to Assign Group Work in Google Classroom

How to Assign Group Work in Google Classroom

Learn how to use Google Classroom's assignments feature to create and manage group projects for students.

Conditional Formatting in Google Sheets: This Week, Next Week, Last Week

We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether a date contained in a cell falls in this week, next week, last week or any other week.

Google Apps: Applying Conditional Formatting Across Sheets

Common wisdom says you just can't apply conditional formatting in a Google Apps spreadsheet using data from a different sheet. But here at THE Journal, we laugh in the face of wisdom, common or otherwise. But is such jocularity is justified? Read on.

conditional formatting in Goole Sheets

Google Sheets: Using Custom Formulas in Conditional Formatting

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to refer dynamically to the contents of a current cell.

item count example in google sheets

How To Get an Item Count in Google Sheets

Here's a quick and dirty formula you can use in Google Sheets to get a running count of cells that contain any value (numbers, dates, text, links, etc.).

 Sample Google Sheet sowing the date extracted from a URL.

How To Extract the Date from a URL in Google Sheets (or Any Spreadsheet)

This question comes up often in user forums: How do I extract a piece of information from one column and put that extracted information into another? For example, if I have a URL in one column, can I extract the date from that URL and put it in my date column so I don't have to the the date manually?

google sheets teaser

Formatting Cells Based on Date Ranges in Google Sheets

In our first tutorial on Google Sheets, we looked at extending the software's default conditional formatting options through the use of formulas. That solution is good for a limited range of dates, but it might get cumbersome in spreadsheets that span longer periods, since each possible date requires a unique formula.

Google sheets conditional formatting date options

Extending Conditional Formatting in Google Sheets Using Dynamic Date Calls

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that date is from the present. But the options available through the Conditional Formatting dialog are limited. Here's a way around those limitations.