Weekly Newsletter Signup

• Upcoming
  Live Online Workshops

  • Excel and SharePoint: I didn’t know you could do that!
  • Easy Tabs Interface - Simple SharePoint Navigation for Complex Information
  • Train the Trainer: Materials and Resources for in-house SharePoint Training
  • Become Your Company’s SharePoint SuperStar!
  • Hack SharePoint Web Part Displays with XSLT
  • Business Solution: Health Care Case Management
  • Killer Calendars in SharePoint
  • The Basics of Content Types
  • Business Solution: Create a Compliance Report Intake System in SharePoint
  • Business Solution: Manage Input with Dynamic Feedback Forms
  • Live Blogging at SharePoint Conference 2009

• Ongoing Series

  • Article Archives (1000+)
    All Authors
  • This Week in SharePoint with Joel
    Joel Oleson
  • jQuery for Everyone
    Paul Grenier
  • The Calculated Column
    Dessie Lunsford
  • The Data View Web Part
    Laura Rogers
  • Stump the Panel: Q&A
  • Subscribe to the Weekly Newsletter

• Authors

  • Dessie Lunsford
  • Laura Rogers
  • Lee Reed
  • Mark Miller
  • Jim Bob Howard
  • Paul Galvin
  • Paul Grenier
  • Toni Frankola
  • Woody Windischman

• SharePoint Resources

  • Bits of SharePoint
  • Codeless Solutions for SharePoint
  • Get the Point
  • Innovation Matters
  • Path to SharePoint
  • Paul Galvin
  • SharePoint 911
  • SharePoint Blank
  • SharePoint Blogs at SharePointU
  • SharePoint for Non-Developers
  • SharePoint Forums at SharePointU
  • SharePoint Screencasts
  • SharePoint Use Cases
  • Social Media Talk Tweets
  • The Sanity Point
  • The Weekly Newsletter  

Problem:  Eric commented on my last article and [basically] issued another challenge.
Will this work for time values?
Solution:  Same concept as adding money.  Grab the values into an array.  Use JavaScript and regular expressions to do some math and massage the data.

To see the formula explained and the code snippet, click “Read more.”

Congratulations are in order for the publication of Dessie Lunsford’s second eBook: Taming the Elusive Calculated Column, Session Two. There have been over 500 downloads in the past 24 hours. What’s going on here? Are you guys short on Christmas presents or what? You’re making Dessie feel like Santa Claus.
Sincerely, congratulations Dessie on a great [...]

Christophe, at Path to SharePoint, created one of the most important scripts for quickly and easily punching up the List View and List Form web parts, the HTML Calculated Column.  His creative uses for this mashup of data and HTML always inspires me.
Thats why I wanted to rewrite his script for jQuery (you still need to make sure your [...]

Heads up!
The next EndUserSharePoint.com newsletter will include a free, downloadable eBook by Dessie Lunsford: Taming the Elusive Calculated Column, Session Two. Dessie has been working on documenting all of the available functions for use in calculated columns. This will be an invaluable resource as you start trying to ‘tame’ the content in your lists and [...]

Overview
In this article, we’re going to be covering the last 4 functions in the "Text and Data" set of formulas for SharePoint.
The four functions we’ll be discussing are:
DOLLAR – Converts a given number into text with it represented in a "Currency Format" and having it’s decimals rounded to a specified place. [...]

Overview
Last time, we looked at 3 functions for formatting the case of text (working with uppercase and lowercase letters, as well as the “Proper” format of first letter capitalized only in a word).
In this article, we’re going to look at a few more tools we have in the “Text and Data” set of functions that [...]

Overview
In this article, we’re going to look at how to transform existing text on a list in order to format it into a more consistent manner.
Typically, you may have many different users entering in form information onto your lists.  Because of this, it’s very common for each user to enter in [...]