Formula

EvansM

Hello Community,

I need help to write a formula to say 

IF [account_number] begin with 6 and [location_name] begin with 6 then add 6 beginning of [Member_number]

so [member-number] should look like 61090440

atcodedog05

Hi @EvansM 

Here is how you can do it.

Workflow:

Hope this helps : )

member.yxmd