Sign in
|
Join
|
Help
in
Current Tags
Mirrored Blogs
External Feeds
(Entire Site)
SharePoint Blogs
The Best Place for SharePoint-related Blogs
Home / Blogs
Get a blog here!
SharePoint University
Downloads
This Blog
Home
Syndication
RSS
Atom
Recent Posts
Branding SharePoint
Troubleshooting: Cannot import Web Part Error
Speaking at the UK SharePoint user group on WCM next week
EndUserSharePoint.com: Taming the Elusive “Calculated Column” – Text and Data (Part III)
Address Fix For Taproom Techie Night Tonight In Atlanta
Tags
.NET
Ajax
ASP.NET
BDC
blogging
Blogging;SharePoint Technologies
Blogging;Technology
Branding
Business Data Catalog
calculated column
codeplex
community
Content Type
deployment
designer
deutsch
Developers
Development
Document Library
Document Management
e_sharepoint
ecm
eHome
End User
Enterprise Search
Events
External Links
features
g_sonstiges
General
General Observations
geschwafel
howto
InfoPath
Information Architecture
Infraestructura
JavaScript
Libraries and Lists
library
Links
Microsoft
Microsoft .Net Development
Microsoft Office SharePoint Server
moss
MOSS 2007
MOSS 2007;WSS 3.0
MOSS2007
Newsticker
None
Office
Office 12
Office Servers
OnePage
Personal
Podcasting
Question of the Day
RSS
Screencast
Search
security
Sharepoint
SharePoint – WSS and MOSS
SharePoint 2007
SharePoint 2007 (MOSS) - V3
SharePoint 2007 Development
sharepoint administration
SharePoint Designer
SharePoint Development
sharepoint server
Sharepoint Technical Info and How Tos
SharePoint Technologies
SharePoint Workflow
Sharepoint: Portal
SharePointCommunity
SharePointPodcast
Silverlight
Social Computing
SPC2008
Tech Stuff
Technology
Tipps
Tips
Tips and Tricks
Tools
training
Uncategorized
upgrade
video
Virtualisation
Web 2.0
Web Content Management
Web design
web part
Web Parts
Webpart
Windows
Windows 2008
Workflow
workshops
wss
Archives
October 2008
(57)
September 2008
(327)
August 2008
(310)
July 2008
(359)
June 2008
(384)
May 2008
(369)
April 2008
(370)
March 2008
(495)
February 2008
(423)
January 2008
(438)
December 2007
(398)
November 2007
(375)
October 2007
(455)
September 2007
(367)
August 2007
(392)
July 2007
(258)
June 2007
(161)
May 2007
(111)
April 2007
(80)
March 2007
(48)
February 2007
(31)
January 2007
(12)
December 2006
(17)
November 2006
(8)
October 2006
(6)
September 2006
(8)
August 2006
(4)
July 2006
(5)
June 2006
(1)
May 2006
(2)
April 2006
(10)
March 2006
(3)
February 2006
(4)
January 2006
(10)
December 2005
(2)
November 2005
(17)
October 2005
(18)
September 2005
(12)
August 2005
(1)
July 2005
(1)
June 2005
(1)
April 2005
(1)
March 2005
(2)
Mirrored Blogs
Browse by Tags
All Tags
»
calculated column
(
RSS
)
calcuations
Content Type
Dessie Lunsford
End User
External Links
Libraries and Lists
moss
Screencast
Sharepoint
Tips and Tricks
training
Web Parts
workshops
EndUserSharePoint.com: Taming the Elusive “Calculated Column” – Text and Data (Part III)
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...
Posted
Oct 06 2008, 03:57 PM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Case Studies in SharePoint Dashboards - My Task Assignments
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...
Posted
Sep 24 2008, 11:42 PM
by
End User SharePoint
Filed under:
Screencast
,
workshops
,
calculated column
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Contacts List (Part II-III)
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...
Posted
Sep 21 2008, 10:09 PM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Post Mortem on Case Studies in SharePoint Dashboards
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...
Posted
Sep 16 2008, 07:33 PM
by
End User SharePoint
Filed under:
Web Parts
,
Tips and Tricks
,
workshops
,
calculated column
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Contacts List (Part II-II)
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...
Posted
Sep 03 2008, 12:25 PM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: How to create links, labels and coloring in a SharePoint list
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...
Posted
Sep 01 2008, 12:15 PM
by
End User SharePoint
Filed under:
External Links
,
Tips and Tricks
,
calculated column
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Contacts List (Part II-I)
Overview Last time, we modified the default “Contacts List” in order to see what other functionality we could introduce that could extend its default capabilities. This is a continuation of the previous article “” in which we created...
Posted
Aug 26 2008, 11:59 PM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Contacts List (Part I)
The default collection of “Lists and Libraries” within SharePoint are a great way for most users to begin collecting and sharing information. Often however, the defaults may not have the full capabilities you want in order to present...
Posted
Aug 16 2008, 02:00 AM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Resource for Calculated Columns
In addition to Dessie’s series on “Taming the Elusive Calculated Column” and his downloadable 51 page Ebook on Calculated Columns, there is another End User resource for calculated columns. Christophe at Path to SharePoint has provided...
Posted
Aug 14 2008, 12:15 PM
by
End User SharePoint
Filed under:
External Links
,
Tips and Tricks
,
calculated column
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Text and Data
One of the more useful categories of functions available to use in Calculated Columns is that of the “Text and Data” set of formulas. Through their use you can combine fields, compare data existing in other columns, apply formatting rules...
Posted
Aug 01 2008, 02:00 AM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Task List (Part IV)
Dessie Lunsford Points-of-Sharing If you haven’t read through the previous three articles in this series (Part I, Part II, Part III), I would encourage you to read them first as we’ll be continuing on with the use of an Excel spreadsheet developed...
Posted
Jul 24 2008, 01:00 AM
by
End User SharePoint
Filed under:
Libraries and Lists
,
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Task List (Part III)
Dessie Lunsford Points-of-Sharing If you haven’t read through the previous two articles in this series (Part I, Part II), I would encourage you to read them first as we’ll be continuing on with the use of an Excel spreadsheet developed in...
Posted
Jul 08 2008, 09:58 AM
by
End User SharePoint
Filed under:
Tips and Tricks
,
calculated column
,
Dessie Lunsford
EndUserSharePoint.com: Taming the Elusive “Calculated Column” - Customizing a Task List (Part II)
Dessie Lunsford Points-of-Sharing If you haven’t read through the previous article in this series and wish to follow along in the walkthrough, I encourage you to read it first, especially since we’ll be working with the Excel spreadsheet we...
Posted
Jun 27 2008, 01:27 AM
by
End User SharePoint
Filed under:
Sharepoint
,
moss
,
Content Type
,
End User
,
Libraries and Lists
,
training
,
calculated column
,
Dessie Lunsford
Taming the Elusive “Calculated Column”
Author: Dessie Lunsford Website: Points-of-Sharing When filling in a form, uploading a document, adding in an Announcement, or simply creating a list to house your favorite movies, you’ll generally be working with multiple columns of information...
Posted
Jun 12 2008, 06:00 AM
by
End User SharePoint
Filed under:
Sharepoint
,
End User
,
Tips and Tricks
,
training
,
calculated column
,
Dessie Lunsford
,
calcuations
Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts