Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

How To Use in Sheets

IF(logical_expression, value_if_true, value_if_false)

External Links

How to Make an Interactive To Do List In Google Sheets

Imagine this kind of to-do list: Any time we check off one of our chores in our list, the text changes to something that shows us what we’ve done. Instead of just a checkbox, the text actually changes.

Automate Google Sheets without Apps Script, without Zapier

Automate Google Sheets without Apps Script, without Zapier. Using a few Google Sheets formulas you can bring automation-esque actions to your sheets. Using these 6 formulas (2 formulas and 2 formula pairs) you can make pure magic inside your sheets. Without learning apps script, and without using a 3rd party automation like Zapier.

21Better Sheets Tutorials

Build a list of domains you can buy right now. Easily check if the domain you want is still available.
Useful for calculation or filters by dates.
Track your goals with a thermometer.
Got a list of names, need to add new ones to main list.
Created a daily email with a motivational quote in the subject.
Covering some of the basics I skipped over in the part 1 video.
A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Create a start time and end time and duration of that, with a little bit of Apps Script.


4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.