I am attempting to make a condition where someone is inputting a new item on a list but for three specific fields, end users can only fill in one of those three. I can't figure out the formula syntax.


  • What are those three fields exactly(single line of text or something else). Can you please clarify your question giving more details? Oct 21 '18 at 13:00
  • The fields are three different choice fields.. We are having an issue where individuals are filling in 2/3 of the fields. We want to minimize this error so the individual can only pick ONE field to fill in. Mind you that there are other fields but these particular ones, only one of the three fields can be filled in. Does this help?
    – Ryan
    Oct 22 '18 at 16:28

You can use PreSaveAction() on new form of list to validate these fields using script editor or adding content editor web part.

Here is how to add script editor in sharepoint.

You can find more details about content editor, here.

And here how to use PreSaveAction().

  • My work does not allow third party applications.. Would you roughly know the formula?
    – Ryan
    Oct 22 '18 at 20:34
  • you dont have to use any third party applications for this. you need to add just single javascript file. Nov 15 '18 at 11:48

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.