Creating a Check
To create your first check open the Check Sheet app from one your spreadsheets as described in Getting Started.
or if you have already created a check you'll see a green
Add
button at the top of your list of checks.You'll then be presented with a blank form as shown below that allows you to enter the details of your check.
A check is made up of the following properties:
- Name: The name of your check, this will be shown in notifications
- Sheet: The sheet which contains the data you want to check
- When: The set of cells that must match if the range contains multiple, not visible for single cell ranges
- Value: The value you expect your condition to match against, it can be one of these types and isn't visible for some conditions
- For: For checks that contain a range of multiple cells this controls whether a notification will be sent for just the first match this is found or for every new match.
- Target: The location the notification should be sent to, it can either be a static value such as an email address or a dynamic target i.e. a value retrieved from your spreadsheet

Last modified 3mo ago