Sunday, October 09, 2016

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

Tuesday, September 13, 2016

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.

Wednesday, June 08, 2016

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: