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  

Dessie and I were talking about the direction of his next series of articles on the calculated column. Here’s the roadmap for those of you who have been following along:
“I still have 12 functions I want to cover in the “Text and Data“ series (I’m trying to get to each and every function available), with [...]

The Overview
So far, in the "Text and Data" set of formulas, we covered the following functions:

CONCATENATE
FIND
LEFT
LEN
MID
REPLACE
RIGHT
SEARCH
TEXT
TRIM

This time, we’ll continue on by exploring a few more, with some simple examples on how we can use them in our formulas.

Getting started
To start, let’s look at our two new functions:
CHAR() – function is used [...]

A fourth module has been added to the Case Studies in SharePoint Dashboards screencast series.
WSS web parts do not include graphing, charting or KPI capabilities. This module, My Task Assignments, demonstrates a possible way to create visual representations within a calculated column of a task list. It was one of the most popular demos in the [...]

Overview

In the previous two articles (Part II-I and Part II-II), we looked at an approach to "Data Validation" in an "Employee Contacts" list by creating calculated columns that perform "Find-and-Replace" operations on a phone number in order to reformat them into a dash-separated style (555-666-7777).
Getting Started
This [...]

I had extremely good feedback from the hundreds of people who participated in the Case Studies in SharePoint Dashboards presentation, but there were problems with VOIP audio and the distribution of login instructions for some that need to be addressed in future  sessions.
Due to problems with the audio for some who attended, I will be [...]

 
Overview

Last time, we began working with the concept of “Data Validation” in a “Contacts” list by creating a calculated column that reformats a phone number from a “space-separated” sequence into a “dash-separated” sequence.
The problem of course, is that as we left it, the only manner in which it would accurately work is if the phone [...]

I received a note from Christophe at Path to SharePoint about a few articles he has been working on. 
There are many people who want to be able to create HTML within a list cell in SharePoint. Using calculated columns to write HTML is a step-by-step process for doing that.
A second desire for many people is to have a [...]