Conditional Formula on Boolean Resulting in "-1"

[kaianderson]

I have a workflow where I'm using Regex Match to create two Boolean fields. I then changed the field type of the match fields to "String" so that I have "T" and "F" values in my data. I then want to use a formula to create a 3rd field that is "T" when either Company_Identifier or Field_1_Matched values equal "T" and "F" when neither of the 2 fields are true.

When I use the below formula on the data in the screenshot above, I get either "F" or "-1" values, and I cannot figure out why.

Anyone have any ideas?

[AbhilashR · Accepted solution]

@kaianderson - modify your then statement THEN = 'T' and not THEN [Company_Identifier]='F'

Attached is a sample for your reference

[kaianderson]

Thanks a bunch, @AbhilashR!