Forum Discussion
Solved
if statement custom column
I have a column "Item" that I would like to find all values start with "SK" or "78", then insert a text "Do Not Use" to the custom column, otherwise, carry the values from column Item over as is. Ca...
I would create a column
_new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])
I would create a column
_new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])