Nicky Hopkins’ Greatest Hits

1. Blues De Luxe (Jeff Beck - Truth)
2. Gettin In Tune (really, all over Who’s Next)
3. Edward the Mad Shirt Grinder
4. Loving Cup - the Glimmer Twins
5. Drowned - The Who
6. Edward’s Thrump Up
7. Highland Fling
8. Volunteers of America
9. Baby’s House - Steve Miller

Simple SharePoint List Item Validation Example

Sometimes SharePoint validation can be touchy. This is a simple example of ...

If you answer "Yes" then you must also complete this other field.

VPN is a choice field. VPN Justification is a single line of text.

The formula is:

=IF(VPN="Yes",LEN([VPN Justifiction])>2,TRUE)

and the User Message is:

VPN justification must be completed

Simple and effective.

Setting a Due Date

This formula worked real well as

• a calculated default value 
• on a date only field 
• to set the due date to today plus two 
• and accounting for weekends:

=Today+2+IF(OR(WEEKDAY(Today)=4,WEEKDAY(Today)=5,WEEKDAY(Today)=6),2,0)+IF(WEEKDAY(Today)=7,1,0)