ignore case in text
Hi Team, Could you please let us know if you have a key word for text compare to ignore case. Basically AB=ab=Ab=aB Here Im trying to compare a column that has "AB" an...
Forum Discussion
So your issue is you have Column A with mixed-case text (that you can't edit) and you need a form rule on Column B to match values from Column A?
Create a helper column Formula - Text and define it as UPPER([Column A]), then match Column B to the helper field instead of to Column A.
Create a helper column Formula - Text and define it as UPPER([Column A]), then match Column B to the helper field instead of to Column A.