formula not working !!!

Question

Hello,

I have a workflow that has 22 statements in this formula and I am needing to add one more but it is not working -I have to make sure the column OtherReasonforDenial has only I&E. I have tried elseif [OtherReasonForDenial] not in ('I "&" E') then 'other reason for denial error' elseif  --Also  elseif [OtherReasonForDenial] != 'I "&" E' then 'other reason for denial error' elseif

I have also tried only using ('I&E') and 'I&E'

Please help!

Thanks!

Veronica

DawnDuong · Answer

hi @VeronicaElse

The operator IN is not used correctly. The correct syntax is

[Field name] IN ([value 1], [value 2], [Value 3]

In your case, you can use the formula:

[OtherReasonForDenial] NOT IN ("I", "E")

the IN operator will result in values of -1 for true and 0 for false.

Dawn.

atcodedog05 · Answer

Hi @VeronicaElse

Hoping [OtherReasonForDenial] is a string type datatype

Try this

elseif [OtherReasonForDenial] not in ("I","E")

And share the error snapshot.

VeronicaElse · Answer

IN (...) Parameter #1 has a  type mismatch--- error given 😞