Notification once an entire row is checked

bradley_B

I am looking to set up a notification once everything in a specific column has been check marked.  Basically I have 10 things that need to be collected by someone every week, they are listed in rows in the sheet and have a checkbox next to them to check once the item is collected.  I want a notification to go out once the last item is checked.

 

Thanks

Mike Wilday

You could set up an additional formula that checks for all of those items to be checked, and puts "sent mail" in the field if so, then trigger the notification to fire when the column changes to "Sent Mail". 

=IF(AND(Checkbox1=1, Chekbox2=1, Checkbox3=1), "Sent Mail, "")

Replace Checkbox 1, 2, 3 with actual column names and that should do the trick. Then set up your notification rules to check the new column with the new formula for Sent Mail.