Workflow condition starts with < N

Tony B
Tony B
edited 10/11/21 in Formulas and Functions

We have a use case where an assignee is variable based on an ID 'number.' The ID Number starts with a letter code, and the assignee is

IF ID starts with A-M

THEN AssigngedTo = User1@domain.com

ELSE AssigngedTo = User2@domain.com


Clarification:

A-M is A through M

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!