Limiting Maximum number of Choices in List
Hi, I have a Column in a SharePoint List for 'Reason customer cancelled Order'. My Choice column has a pre-set number of options (around 10) which detail reasons why customers might cancel. (E.g. 'Product not available in the right colour', 'Long delivery times', 'Bought from competitor'). I want to limit the number of maximum choices someone can pick using Column Validation to 3 choices max. (E.g. Someone can then tag the order being cancelled for the reasons of 'Long delivery times' & 'Bought from competitor'). I don't want to create three different Choice columns each maxed at 1 choice entry as this is not compatible for a good user experience when inputting data into the List. Any help would be appreciated if anyone knows what the correct code for validation would be!
Sharepoint Column Validation: Need to access previous version of data through formula
I have a sharepoint list where I need to set a validation setting for a single column. This validation should make sure that the current modified value must not match with the previous value (by getting the value from previous version). Any idea how to do it in column validation? I need to access the immediate previous version of the list item get value from it and use it in formula for validation purpose.