Hi,
if Contains([Keyword List2], "") then "CoPayee Containing SS_ACC" else flag endif
Is this correct formula to pull out all the ones that have a keyword list? I am trying to pull out in a seperate tab if the keyword list is found by naming it that
thanks
currently what I have but it is not labeling them"CoPayee Containing SS_ACC" - it is not showing any
The way you have it written now you are looking for blanks in the Keyword list column. If there are any blanks then replace the blanks with "CoPayee Containing SS_ACC". Your flag needs to be surrounded by a quote for the formula to replace the field with "flag" when there are no blanks.
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |