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  

Every once in a while, good scripts need a second look. The calcHTML idea popularized by Christophe has such potential for frequent use, I decided to see if I can improve on my previous work (link).
First, I noticed that I created an unnecessary extension of jQuery with “$.calcHTML = function()…” I stopped that [...]

Using the method of building out a “Truth Table” then a “Flowchart” for each and every nested formula may not always be the best approach for you given the time it takes to build them out, but as the complexity of your formulas increase, you might find that having them can decrease the “headache-time” of debugging and troubleshooting when your logic goes awry.

You now have a complete formula that includes every step of the logic needed to ask each question in a manner that allows for each possible answer

To test what we have so far, let’s look at our existing example and build upon it to make it even more complex then use our “Truth Table” and a basic hierarchical flowchart to create our final formula. Now that we have a complete list of all expected results, we can build out a basic flowchart of how the logic should travel (based on these results).

The [Today] thing gives people fits. It just doesn’t work in calculated columns like you want it to.
Here’s a slick way around it using some jQuery. To test this example for yourself, place the code sample in a Content Editor Web Part on the same page as a standard Discussion List [...]

This question of the day comes from iamspartacus in Stump the Panel.
Any way to have MOSS list the time range of an event in a Calendar View of a list instead of just the start time? Need to create an after hours schedule that shows start and end times but don’t really want to buy [...]

In this article, we’ll be discussing the single function belonging to the “Lookup and Reference” set of SharePoint formulas, the “CHOOSE” function.
Background
Since the formulas available in SharePoint are “Based” on what’s available in Excel (and since this function is part of the “Lookup and Reference” set within Excel as well) they were nice enough to [...]