I have a large list that is used to manage Projects, I want to trigger an email to certain users when a Project Status is changed from "New Project" to "In Assessment" etc.
I've been looking at having two additional columns Previous State and Previous State 2.
- When a new item is created the Project Status is copied to the Previous State Field.
- When an item is modified the Previous State value is copied to the Previous State 2 field.
- If the Project Status and Previous State 2 values don't match an email would be sent.
Would this logic work and how can i avoid an email being sent every time an unrelated field in the list is updated?