Workflow condition starts with < N

Tony B

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

Andrée Starå

Hi @Tony B

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Tony B

Hi @Andrée Starå,

I hope this note finds you well.

Please find the screenshot below.

Use case: When the AR number's first letter is A through M, it is assigned to one worker, when it starts with N through Z, it is assigned to a second.

I appreciate any and all help you can provide.

Andrée Starå

Hi @Tony B

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

ygoldgrab

Hi @Tony B ,

I had a similar case and this is what I did.

https://community.smartsheet.com/discussion/comment/318598#

I used a match formula to reference another sheet where I had the ABC running down one column and referenced the range (in ABC List Range 1 from Letters A- J), if no match then I knew it would be Manager B. This worked great!

=IFERROR(IF(MATCH(LEFT(fullname@row), {ABC List Range 1}, 0) > 0, "Manager A", ""), "Manager B")