In a List, I've got several number columns that users enter a value in for # of tickets.

Event 1 - [ ] tickets
Event 2 - [ ] tickets
Event 3 - [ ] tickets

Is it possible to validate the sum of the three ticket values? For instance, let's say I want to cap the number of tickets at 8, how can I validate to check the sum of the three columns and compare that to 8?

Many thanks!

  • Use JavaScript to validate the fields – Keerthi Nov 17 '15 at 20:20

Go to List tab>List Settings>Validation Settings.

Enter =(sum([Event 1],[Event 2],[Event 3]))<=8 in the Formula box. Enter some error text in the User Message box.

Validation Settings

Now if a user tries to save, and the total tickets is more than 8, it will show the error message, and not submit the form until it is corrected.

Error Message

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.