I have an if statement which once satisfied, I want it to move to another list.
If each of these columns is either "Approved" or "Not Applicable" it should move the item to a new list.
This is what I have tried:
If Current Item:Column1 equals Approved
or Current Item:Column1 equals Not Applicable
and Current Item:Column2 equals Approved
or Current Item:Column2 equals Not Applicable
and Current Item:Column3 equals Approved
or Current Item:Column3 equals Not Applicable
and Current Item:Column4 equals Approved
or Current Item:Column4 equals Not Applicable
and Current Item:Column5 equals Approved
or Current Item:Column5 equals Not Applicable
and Current Item:Column6 equals Approved
or Current Item:Column6 equals Not Applicable
then Copy item in Current Item to List2
Sometimes one or two columns won't be set to Approved/Not Applicable and it will still copy the item.
Is there another way to do this?

0 commentaires:
Enregistrer un commentaire