formula for specific doc #'s

[ttiverson98]

I am trying to create a formula that will return doc #'s starting with a specific number combination then assign them to a Category

If Doc # starts with 19 (and contains only 7 characters), then apply "A" to Category

If Doc # starts with 40 (and contains 10 characters), then apply "B" to Category

Thanks,

Todd

Desired output

Doc#                Category

1912345                A

1912999                A

1999999999          other

4000000001          B

4000009999          B

409999                  other

[atcodedog05 · Accepted solution]

Hi @ttiverson98 

Formula like below should work

IF StartsWith(ToString([Doc# ]), "19") 
and Length(ToString([Doc# ]))=7
THEN "A" 
ELSEIF StartsWith(ToString([Doc# ]), "40") 
and Length(ToString([Doc# ]))=10
THEN "B" 
ELSE "others" ENDIF

Workflow:

Hope this helps 🙂