Yoni Goldberg

SharePoint Expert, Human Workflow specialist. WWW.GOLDBERGYONI.COM

Posts Tagged ‘Formula

List validation accepts excel functions

leave a comment »

List validation in SharePoint 2010 is another great step toward the development of “Zero Code” enterprise applications. ‘Excel style’ validation formulas can be defined to determine the validity of new list items, once a user try to add new list item, the formula is executed against the item columns. It should be noted, that excel functions are also valid for the validation formulas, this gives the user much more power in defining the validation rules. For example, in a calendar, to prevent employee from catching a meeting room for days, one can define a validation rule: The maximum meeting length is less than 2 days using the excel function “DateDif”:

Read the rest of this entry »


Written by Yoni Goldberg

May 25, 2010 at 10:41 am