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 · Accepted solution]

Hi @EvansM 

Here is how you can do it.

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@EvansM,

Please see below :

Hope this helps!

Regards,

[EvansM]

@atcodedog05  Thanks

[atcodedog05]

Happy to help : ) @EvansM 

Cheers and have a nice day!

[EvansM]

@messi007 Thanks