I have a form where people will enter the department they are working in. This is a single choice item. Then they will select the departments that they would like to obtain training in. This is a multi choice item. I need some validation to make sure that they don't select the department they are currently working in as an option that they want to get training in. I tried a couple things, but I couldn't get it to work correctly and searching hasn't helped. I am probably searching for the wrong terms. I tried a formula validation =If(search[transfer dept],[current dept],false,true) but it failed on all entries.
Thanks for your help