Data Validation

Sep 15, 20233 min read

How To Highlight Duplicate Rows in Google Sheets

Highlighting duplicate rows in Google Sheets can be really useful to draw attention to duplicate data quickly.

Jun 24, 202312 min read

Task List in Google Sheets with Kanban & Automated Status Tracking

Efficient task management is essential for maintaining productivity. This tutorial will explore a powerful solution to streamline your tasks

Jan 19, 20233 min read

Dependent Drop-down Chips in Google Sheets

You can take drop-down lists to the next level by making them dynamic with dependent Drop-down Chips

Dec 28, 20224 min read

Create a Dropdown list with Smart Chips in Google Sheets

Dropdown chips are a better-looking version of the old-fashioned dropdown lists you could create using Data Validation.

Aug 18, 20224 min read

How to Create a Drop-down list in Google Sheets

Creating a drop-down list in Google Sheets is super easy to make with Data Validation and even easier to use. Find out how.

Jul 24, 20222 min read

How to use Data Validation to enter dates

Entering dates into a Google Spreadsheet is straightforward; you can simply type the date out in a cell, but there is a better way; by...

Jul 17, 20223 min read

How To Return Multiple Columns with VLOOKUP and Data Validation

The VLOOKUP function is unquestionably in my top 5 most used functions.