Help

REGEX_MATCH formula works on one table and not the other

Topic Labels: Formulas
Solved
Jump to Solution
1131 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brendan_Picha
4 - Data Explorer
4 - Data Explorer

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!?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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")

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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")

Brendan_Picha
4 - Data Explorer
4 - Data Explorer

Scott,

You are the man!

Thank you!