Hi I would like to find out a way to replace certain values in the second column.
My criteria: If customer = Sally, I want to blank out the items purchased in the existing column. Thank you in advance!
Customer Name | Items purchased |
Richard | Hat |
Sally | Coat |
Mary | Gloves |
Jonathan | Socks |
Sally | Socks |
Solved! Go to Solution.
Hi @BJSOON,
To do this, connect a Formula tool to your workflow. Then, where it says Select Column, select the Items purchased field. In the expression editor, enter the following expression:
IF [Customer Name] = "Sally"
THEN Null()
ELSE [Items purchased]
ENDIF
This will convert all records where Customer Name is Sally to a null value.
Alternatively, if you want a blank value instead of null, replace Null() with "".
Let me know if you have any questions.
Thanks,
Josh
Thank you so much!