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
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
Want to test this out for yourself? Install Check Sheet now for free.