If startswith([accountnumber], “1”,”2”,”3”) then B else P endif

[jmfaizaan]

The formula throws an error saying that the startswith function has very few arguments. Can someone help please?

[Sarreddy]

My solution @jmfaizaan 

[flying008]

Hi, @jmfaizaan 

The function StartsWith only have most 3 arguments for calculation, your formula syntax like incorrect.

1st argument:   Field Name or String.

2nd argument: String to find.

3rd argument: Case-insensitive parameter. default is 1.

So you maybe can try this formula:

If StartsWith(ToString([accountNumber]), "1") or StartsWith(ToString([accountNumber]), "2") or StartsWith(ToString([accountNumber]), "3") 
Then '8' Else 'P'
Endif

[DenisZ]

Please see an alternative solution

Alternatively, you could solve this with RegEX

[CarliE]

@jmfaizaan ,

I used an IN statement to have a little bit of a cleaner formula -- if Left([AccountNumber], 1) in ("1","2","3") then '8' else 'P' endif

If this helped to solve your problem, please be sure to mark it as a solution so other users on the community can benefit :)

Thanks!