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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!