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 A1
or 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?