Simple IF formula getting an error (from a "CONTAIN" calculation column)

[LissieDomingo03]

Hi!

So, I calculated a field to look for "100" in a cell. This will return "true" if there is a "100" and this seems to be working fine.

Next, I tried making a simple IF calculation to return "100" if the look-up value is true. I can save the formula but I am not able to save the story or preview. Error below.

Any ideas?

[LissieDomingo03]

Up

[subbareddyven]

Hi @LissieDomingo03,

Please try condition by changing like below

IF(CONTAIN([Employment#Job Information#Employment Status_Description] , "Act") ,"Active" ,"Not Active" )

Regards,

Subbu