Can I use a sheet to define notification contacts in another sheet?
I have multiple people wanting to be notified when certain criteria occur. I have that information in another sheet. For example Mary wants to be notified if A, D and Z occur and Steve when B, C and D occur. Mary is a row in the sheet with checkboxes for the criteria she wants to see, Steve the same.
Help Article Resources
Check out the Formula Handbook template!