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
    Commented Nov 17, 2015 at 20:20

1 Answer 1


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 and acknowledge you have read our privacy policy.

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