Assigning Client based on Last Name

[Drew_Nemer]

Does anyone know how to simply program an automation that would allow for clients to be assigned to employees based on first letter of last name.

So if clients with last names starting with:

A - G --> Employee 1

H - M --> Employee 2

N - S -->  Employee 3

T - Z --> Employee 4

i figured this might be a combination of a formula field that just isolated the first letter of last name. But i think there should be a quick second step that would maybe group letters in alphabetical divisions easier than just manually input a condition automation for each letter.

[Ron_Daniel · Accepted solution]

Drew,

The first part is easy: just a formula of 

LEFT({Last Name}, 1)

There are a lot of ways to do the second part, and this is probably not the sleekest one, but what about making a 26-record table of the letters, and linking them to the employees?

Then all that would be left is to write an automation that adds (or you could just copy/paste) the letter to the linked record field, and a lookup table showing the employee assigned to them:

[Drew_Nemer]

i think that solution is as good as any. thank you