Why is SmartSheet contacting everyone in the contacts column even when they don't meet the criteria?

dmartin
dmartin ✭✭
edited 12/01/23 in Formulas and Functions

I've been working on setting up a workflow sheet for volunteers in a graduation ceremony. My columns are "job, first/last name, date/time, email, phone number." The "Email" is a contact column and the picture shows how I have set up the workflow. Why is the sheet sending the message to every contact in the email column when the parameters of the workflow only allow for certain "Jobs" to be the recipients?? Please help!

Do I need to made a condition that "Item" aka "Job" contains only the one I want to be sent the message?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!