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? – Ganesh Sanap 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().

| improve this answer | |
  • 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. – Ganesh Sanap 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.