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 = [email protected]

ELSE AssigngedTo = [email protected]


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!