Filter one column, if the value of another column is exists in it

Hi community,

It’s probably an easy thing, but me + ChatGPT are not getting it to work.

See here:

Hi @Isebar_DE,

please check if that is your desired output:

Hi @Isebar_DE ,

Not sure what you’ve tried, but you’re looking for the ContainsText() formula.

So create a filter, and choose to write your own formula for the filter. Then…

thisRow.Column2.ContainsText(thisRow.Column1)
2 Likes

@Nick_HE thats it! Thx Nick & @Jannis

1 Like