Notification once an entire row is checked
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
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives