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
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!