In this article, you will learn how to make a tick box and utilize it in Google Sheets. It is helpful because you can use a check box simply as a tick box for to-do management or as a trigger of Conditional Formatting with other formulas.
Check this article if you are interested in Data Validation.
As a check box can switch two values in a cell, it is often used with other functions such as IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, and/or Conditional Formatting. In the following cases in the picture, the checkboxes are general check boxes used as Conditional Formatting triggers.
Example 1: Project management: In this example, when you check a box, the entire row that has the tick box is highlighted in dark grey.
Example 2: Formatting adjustment: When you click the check box, font colors change to block, and fill colors turn white. This is effective when you print out your spreadsheet with simple formatting.
The following picture shows the Conditional Formatting settings for the two examples above.
Check these articles if you are keen to learn more about Conditional Formatting.
Conditional Formatting in Google Sheets: Explained
Conditional Formatting Based on Another Cell Value in Google Sheets: Explained
Are you learning this tip to build a financial model or financial KPI dashboard, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
If you don’t get the right answer to your question in this article or you have other questions on logic formulas, you may find the answers in the following articles.
Should you need to learn about the IF or IFS formulas, check the following articles.
How to Use IF Function in Google Sheets
How to Use IFS Function in Google Sheets
If you want to learn about how to use the AND and OR formulas, visit the web pages below.
AND Function in Google Sheets: Explained
Learn how to do this step-by-step in the video below 👇