How can I validate a drop down list? I have a "Material Requested" column and a "Issued" or "Returned" column. If a item gets requested we choose issued. I want to make sure the Item is returned before it get issued again. Basically, I want to enforce unique values on the "Material Requested" Column


That means, you want a “Material Requested” to be able to be issued only after it is returned.

You can enforce unique values for “Material Requested” column. This feature prevents users from duplicating data.

enter image description here

If user wants to issue/return the existing “Material Requested”, he can only edit the item and modify "Issued/Returned" column to set the status. So that, user cannot issue “Material Requested” again before it get returned.

  • The "Material Requested" is a multiple choice, Drop down. When I enforced the unique values it doesn't let me issued anything unless I returned the previous material. – Pablo E. Jan 19 '18 at 9:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.