There’s no easy option.

One solution is to merge the cell across from your condition column – if someone duplicates a row they’ll still have the value merged and it looks nicer than having a column of N/A

The other approach I tend to use is just to set the column heading to be “must be N/A” rather than retract the person.

 

Thomas