Compare two text fields.
I am trying to compare two text fields [Field1] and [Field2]. If fields do not match, I want to say ?Mismatch.? The example below is a match; I need to create a formula that will always t...
Forum Discussion
If I wrote the formula like this will it return only mismatches:
If([Customer - Related Client]=20,
If(Length([Customer - Enrollment - Meter Number]) = Length([Customer - Meter number]) and Contains([Customer - Enrollment - Meter Number],[Customer - Meter number]),"Meter number does not match enrollment"&"\n")
)&
If([Customer - Related Client]=20,
If(Length([Customer - Enrollment - Meter Number]) = Length([Customer - Meter number]) and Contains([Customer - Enrollment - Meter Number],[Customer - Meter number]),"Meter number does not match enrollment"&"\n")
)&