Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Setting up reminder based of rating field

Topic Labels: Formulas
Solved
Jump to Solution
1229 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Dustin_Good
6 - Interface Innovator
6 - Interface Innovator

Just started working with a dental lab and I’m trying to create a base for targeted outreach to dental offices. After being out in the field today I have entered my notes and assigned a rating to each office. I would like to use 4 stars or 5 stars ratings to trigger an email automation to respective teammates about these particular offices.

1 Solution

Accepted Solutions
IF(OR({Prospect Rating}=4, {Prospect Rating}=5),'Trigger Reminder')

See Solution in Thread

3 Replies 3
Dustin_Good
6 - Interface Innovator
6 - Interface Innovator

May have figured it out…

This works for 4 stars IF({Prospect Rating}=4,‘Trigger Reminder’),

but how do I write it to work for 4 and 5 start ratings?

IF(OR({Prospect Rating}=4, {Prospect Rating}=5),'Trigger Reminder')

Thank you @Vivid-Squid !