Getting notified when a row is updated

Similar to checking when a column is updated to get a notification based on a row being updated you should include a reference using A1 notation to that row. For column 2 it would be 2:2. To exclude the first column you can start from the second row like so: B2:2.

For example the check below will send an email whenever a date is found in row 2 (excluding column A) where the temperature was below 15c.

If you wanted to check if all the temperatures were below 15c you could change the When property of the check to Every Value. Similarly if you wanted to check none of the temperatures were below 15c you could set it to No Value.

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