I have a multi-condition if formula:
The data says “Thomas” not “thomas” so unfortunately the above returns nothing. If I change the values to “Thomas” it returns records.
How do I convert everything to lower case or ignore the case?
I know from reading related topics I need to try to utilise LOWER() somehow but I can’t work out what to wrap in the formula above despite trying a lot of different things.
Any help would be greatly appreciated.