Check Sheet Logo
Check Sheet

Getting notified when a range of cells is updated

To get a notification based on a range of cells being updated you should include a reference using A1 notation to those cells in the range of the check.

For example the check below will send a Slack message when any of the tasks in the range B2:B i.e. the entire column except the header row has the value Done.

Checking when a range of cells is updated

If you wanted to check when all the tasks were completed you could change the When property of the check to Every Value. Similarly if you wanted to check when no tasks were complete you could set it to No Value.

Want to test this out for yourself? Install Check Sheet now for free.