Avoiding (email) notifications if assigned to = modified by

Hi all,

I have set up a market research project plan with around 60 tasks. Each task is assigned to specific person(s) (could be multiple). I have a workflow where they 'assigned to' contact receives a (email) notification if the row on which he/she is 'assigned to' is changed. However, I only want them to receive (email) notifications if the cells in the row are updated/changed by a different person. So not receiving notifications if 'assigned to' = 'modified by'.

It does not seem to be feasible with a formula as 'modified by' is an email address and 'assigned to' is a contact person.

Any ideas?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!