Checks

Everything in Check Sheet is based upon "checks", a check will monitor your spreadsheet for changes in the background and send you notifications if a certain condition is met.

You can create several checks and we will evaluate the state of your checks whenever:

  • Your spreadsheet is updated

  • A form that is linked to your spreadsheet is submitted

  • Approximately once per hour

When creating a check you specify the range of cells that you want to monitor which can be a single cell such as A1or an entire column such as `B:B`.

In addition to the range you also specify a "condition" that we will evaluate against each of the cells in your range such as is the value equal to the text "Done" or is it greater than 5. If a cell in your monitored range is modified and matches your condition it may trigger a notification to be sent.

Check Sheet will remember the positions of the cells in your spreadsheet that match the condition of your check so you won't be sent a notification more than once about the same cell.

When configuring the notifications for your check you can choose whether you want to be sent a notification every time a new value is found to match your condition or just the first time only.

Last updated

Was this helpful?