CONTAINS ENTIRE COLUMN WITH SPECIFIC DATA OR STRING

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.

Developer

Developer Tools

Designer Cloud

Accepted answers

binu_acs

@Johmz one way of doing this

Check_STatus_31032025.yxmd

flying008

Hi, @Johmz

FYI.

录制_2025_04_01_09_14_00_786.gif

All comments

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.

binu_acs

@Johmz one way of doing this

Check_STatus_31032025.yxmd

flying008

Hi, @Johmz

FYI.

录制_2025_04_01_09_14_00_786.gif

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703