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?
Solved! Go to Solution.
@kaianderson - modify your then statement THEN = 'T' and not THEN [Company_Identifier]='F'
Attached is a sample for your reference
Thanks a bunch, @AbhilashR!