Prevent adding a user in column A if it exists in column B

%3CLINGO-SUB%20id%3D%22lingo-sub-1749933%22%20slang%3D%22en-US%22%3EPrevent%20adding%20a%20user%20in%20column%20A%20if%20it%20exists%20in%20column%20B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1749933%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20have%20a%20list%20which%20as%20two%20people%20or%20group%20column%2C%201)%20Sign%20off%20-%20Awaiting%20and%202)%20Sign%20off%20-%20Completed.%3C%2FP%3E%3CP%3EBoth%20columns%20accepts%20multiple%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20prevent%20adding%20a%20user%20in%20Awaiting%20column%20if%20the%20user%20exists%20in%20Completed%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20achieve%20it%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1749933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

Hi all,

I have a list which as two people or group column, 1) Sign off - Awaiting and 2) Sign off - Completed.

Both columns accepts multiple users.

 

I want to prevent adding a user in Awaiting column if the user exists in Completed column.

 

How can I achieve it?

Many thanks in advance.

0 Replies