Apr 01, 2021 10:34 AM
Hello,
I’m pulling my hair out… I have the following formula:
REGEX_MATCH({Products},"Personal")
{Products} is a ‘A Name’ column and the above formula produces a 0 if “Personal” is not present in the column’s field and a 1 if “Personal” is present in the column’s field.
Using the same formula on a different table:
REGEX_MATCH({Products},"Personal")
{Products} is a ‘Lookup’ column and the above formula produces a 0 if field is blank and a #ERROR! if not blank.
The only difference between the two scenarios is the top formula is checking a ‘A Name’ column and the bottom formula is checking a ‘Lookup’ column.
What am I missing? Why am I getting an #ERROR!?
Solved! Go to Solution.
Apr 01, 2021 10:46 AM
Welcome to the community, @Brendan_Picha!
A lookup field is not a string, it is actually an array.
So you will need to turn it into a string first by adding a blank string after it like this:
{Products} & ""
So your entire formula would look like this:
REGEX_MATCH({Products}&"","Personal")
Apr 01, 2021 10:46 AM
Welcome to the community, @Brendan_Picha!
A lookup field is not a string, it is actually an array.
So you will need to turn it into a string first by adding a blank string after it like this:
{Products} & ""
So your entire formula would look like this:
REGEX_MATCH({Products}&"","Personal")
Apr 01, 2021 10:54 AM
Scott,
You are the man!
Thank you!