Sharepoint Survey - List Validation with multiple formulae and different 'User Message'


  • I am creating a survey in SharePoint using the Survey app. Where I need to validate entries in a single question (column) I have done this in the 'Column Validation' fields for that question.

    In a number of cases I need to evaluate two or more fields from different columns (in the same row), for example to check that the date entered in one is at least six weeks after the date in another.

    I can do this using List Validation (Validation Settings) but only once per Survey it seems. So once I have evaluated something and provided a user message relevent to that validation I cannot then create a second, or subsequent separate list validation formula and associated user message.

    Is this a limitation or am I missing something?

    Friday, July 29, 2016 12:19 PM