Multiple Variable Notification Help

ayoder13

I am trying to send notifications based on multiple cell data but the default is set to "or when".  I need both variables to be met before sending the notifications.  I would hope this is easy and I am just not seeing it.

Deb Gordinier

I'm curious what others say on this one.  I thought it would be an easy one but I think you have to create and IF statement then create the alert based on the results of that formula.  

Andrée Starå

Hi,

Depending on your specific use cast this can probably be set up with the help of helper columns. For example. When criteria 1 and 2 are correct a checkbox is checked, and that will trigger the rule.

Would that work?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting