3 Advanced Tutorials for the IF() Formula in Google Sheets

3 advanced Google Sheets IF() formula tutorials. Improve your spreadsheet skills with password protection data, email notification.

3 Advanced Tutorials for the IF() Formula in Google Sheets

You’re the master of the IF() formula and there is no doubt that you use it well. How about challenging yourself by diving deeper into these three advanced IF() formula tutorials?

Password Protecting Data In a Google Sheet

**Note: The link to this video is the same as Part 2. Tell Andrew.

Password Protecting Data In a Google Sheet (Part 2) The Basics

This is an addition to the tutorial on how to password protect data in a Google Sheet, which covers some of the basics that I skipped over in the first part. Watch and learn along with me as I talk more about this topic.

Sheet Stories / Video Notes + ADDED: Email Notifications

Add video notes through Custom menu, complete with video thumbnails. To make it even better, I’ll show you how you can set up email notifications by using Google Apps Script. Receive email notifications so you never miss out on what’s happening in your sheet.

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

In this tutorial, I’ll show you how you can delete videos that are in your Google Sheet for more than 24 hours. This is something similar to Instagram Stories, where you only share a video that’s viewable for only 24 hours. That way, you can keep your sheet updated with only the most recent data that you want to share.

For free tutorials featuring this formula, you can check out these other videos: