Two Separate Contact Columns - One Notification if Same Contact in Both

I have two separate contact columns: each have different notification settings. Is there a way to not send two different notifications if the contacts are the same in both columns?
E.g. Manager column + Requester column
If the Requester is the same as the Manager - only send one notification.
Thank you!
Best Answer
-
I would suggest a checkbox with a very simple...
=IF([First Contact]@row = [Second Contact]@row, 1)
This will check the box if they match.
Then in your Automation, you can set you condition to either send to the first if the box is checked or both if it is not.
Answers
-
I would suggest a checkbox with a very simple...
=IF([First Contact]@row = [Second Contact]@row, 1)
This will check the box if they match.
Then in your Automation, you can set you condition to either send to the first if the box is checked or both if it is not.
-
Duh ๐คฆโโ๏ธ- YES - this works! Thank you so much for the speedy response!
Help Article Resources
Categories
Check out the Formula Handbook template!