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  

The “AND” function is similar to the “OR” function in that it will look at up to 30 different values for comparison, but it’s difference is that in order for the final “Result” to be “TRUE”, each and every condition must be true in the entire check or the end result will always be “FALSE”.

The script below, combined with such a list view, will plot a Google Chart showing those totals dynamically. The chart scale is automatically adjusted with the maximum value to be charted so it fits the designated size in the script. Once implemented, you can hide the list view web part so only the chart will render on the page. You can also play around with chart parameters within the script, to change chart type, style, size, colors or even build more complex charts. Take a look at the Google Chart API page for reference.

If you are a regular follower of this site, you know that I have a high regard for Christophe’s No Deployment Solutions at Path to SharePoint. I use his solutions in the live online workshops, especially when it comes to color coding lists and calendars.

I recently discussed several improvements to the Preview Pane but Live Events, using event delegation, holds the greatest benefit. It also presents the greatest challenge to someone new to scripting. But first, I will “walk the script” and point out which parts do what so you can make your customizations as needed.
Click “Read [...]

As I was putting together the Calculated Column module for the Excel and SharePoint live online workshop, I pinged Dessie Lunsford to see if he had any material I could use to show people how to generate formulas in Excel that could be transformed into a formula for a calculated column in SharePoint.

I receive a lot of great feedback from posting my code samples on EndUserSharePoint.com. The kudos and encouragement give me the energy to tackle new ideas and while responding to questions about some of my earliest examples.
For instance, the Preview Pane was a big hit. People loved hovering over something and watching the [...]

Dessie Lunsford continues his work on the SharePoint calculated column in the latest eBook in the series, Taming the Elusive Calculated Column – Using Logic in Formulas. In this latest installment, we have wrapped up into one eBook package, the beginning steps of how to create logical formulas in SharePoint’s calculated column. Dessie walks through a step by step process explain in an extended deepdive how to get started with logical formulas.