Hello,
I have a workflow where I have DATA column containing document number and TEXT column with a string where this document number can be found as a part of a string. I need to check all the fields in column TEXT to check if in the string I can find document number from column DATA.
I am not searching for line by line check but the whole TEXT column range for each cell in column DATA.
I would appreciate if anyone could help on that.
Best Regards
Hi @u1070365,
You need to use this formula:
FindString( [TEXT],[DATA])
You will get 0 if you got a match and -1 if not.
in addition to @Emil_Kos 's solution - you can use a filter tool with a Contains function
That would filter out all the rows that have this particular text in them.
e.g. contains([my field], 'Cat')