IF and Contain Formula

[DanGordon7]

Hi,

I have a scenario where I need to set a value range from 1 to 4 based on a name appearing in two columns and then if this contains a "-" sign.

In the below example, the focus is on Company A.

If this company is showing in the In column and the value does not contain a "-" I need to automatically populate a 0. If there is a "-" sign within the value field the ID should be set to 2.

If Company A is showing in the Out column and the value does not contain a "-" sign within the value field I need to set a 3 and a 4 if this contains a "-" sign.

Many thanks,

[mceleavey]

Hi @DanGordon7 ,

Can you post the data rather than a screenshot so we can help?

Thanks,

M.

[Maskell_Rascal · Accepted solution]

Hi @DanGordon7 

This formula would work for the scenario you provided. 

IF [In]="Company A" AND !Contains(ToString([Value]),'-') 
THEN '0'
ELSEIF [In]="Company A" AND Contains(ToString([Value]),'-')
THEN '2'
ELSEIF [Out]="Company A" AND !Contains(ToString([Value]),'-')
THEN '3'
ELSEIF [Out]="Company A" AND Contains(ToString([Value]),'-')
THEN '4'
ELSE ''
ENDIF

Cheers!

Phil