I've a list which has 30 column fields. One of the fields is Annualized benefit and Review status & Review status(before)
Annualized benefit is a numeric field (user input) and Review status is a drop down option, Review status(before) will get the value from Review status.
Requirement: I want to trigger an email to users on meeting all the below 3 conditions
1. Annualized benefit field is modified
2. Review status value = completed
3. Review status(before) value = completed
I can do it for 2 & 3 but unable to crack it to get #1 also included.
TSR