So, this post is a quick step-by-step on a couple of cool things you can do with SharePoint 2007 and Microsoft Word 2007 integration

How to reference a ‘Multiple Lines of Text’ column in a ‘Calculated Column’ to display a complete list of appended changes to all items on a list as a group – in 10 Easy Steps

How to reference a ‘Multiple Lines of Text’ column in a ‘Calculated Column’ to display a complete list of appended changes to all items on a list as a group – in 10 Easy Steps

How to reference a ‘Multiple Lines of Text’ column in a ‘Calculated Column’ to display a complete list of appended changes to all items on a list as a group – in 10 Easy Steps

Most organizations have been using Excel to do analysis, create charts and design dashboards for years, yet there is a lot of functionality in Excel that is not easily accessed in SharePoint, sometimes even for those with Excel Services. The question becomes, how does one translate their work from Excel to SharePoint? This means more than linking to an Excel workbook in a Document Library; rather, it requires displaying the charts and dashboards directly within SharePoint.

Two things really. The first is that SharePoint Designer became free and all the ideas, projects and requests that had been labeled “I’ll do them when they spend the $” were all green lighted. If you have read my earlier posts and case study you’ll know that I have had a fair amount of time in front of people selling MOSS. In each group there are always a few or so the saying goes, but in this case they weren’t what you’re thinking. They were the minority, the ones who see the value and begin to research and think along side as you move forward. Needless to say the four key elements that are recurring eyebrow raisers are: Branding, Versioning, Security, and Workflows.

I couldn’t sleep last night because a simple work-around that has escaped me for at least a year came to me as the full moon was setting. The dilemma of not being able to see every version of a notes field in a SharePoint List has frustrated me and others for many moons. This solution (work-around) could not be simpler. Here’s the rub. I have a list and the Notes field is set with versioning “on”. Because I want everything and I want it now, the “View Entries” link to the item’s DispForm is a headbanger. JavaScript or other code solution haven’t seemed to surface yet.

When it comes to SharePoint, the most important feature is the ability to manage your documents from a central location with all these cool features like versioning, permissions, workflows and stuff

Janis Hall from MindSharp has written a thoughtful post for the Get the Point Blog on the criteria to use when deciding to create a new library. While not comprehensive, it touches on major issues to consider when deciding how to structure your data. Key points:

Efficiency of Access to the Data (metadata)
Save Time and Effort [...]