CONTAINS ENTIRE COLUMN WITH SPECIFIC DATA OR STRING

[Johmz]

Hi,

I need help to create syntax to identify the column if one the row contains specific value/string/data then create new column with unique value like example below if the STATUS column contains pending then create REVIEW column with HOLD value for the all rows.

[OTrieger]

@Johmz 

You can use the Formula tool.

If you know what is the criteria then you can define it in an IF formula.

[Johmz]

I tried to use Contains but it only applied per row. like if CONTAINS([STATUS],'PENDING') then 'HOLD' else 'PROCEED' Endif. its only change the row for pending but not the entire column

[OTrieger]

interesting as it should, as you give the 2 arguments.

[binuacs · Accepted solution]

@Johmz one way of doing this

[flying008 · Accepted solution]

Hi, @Johmz 

FYI.