Get notified when a range of cell values change
To get a notification via Email, Slack, Microsoft Teams, Discord or Google Chat when a range of cell values are changed or updated in Google Sheets 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.