A community foundation ensures its survival by sustaining and growing its network of donors, volunteers, and consumers. For the Community Foundation of Greater New Haven (Connecticut), SharePoint is the technological linchpin that facilitates collaboration among the foundation's internal employees, community affiliates, and partners, which include a board of directors, other nonprofits, and businesses. In a recent conversation, Richard Drolet, the foundation's director of MIS, and I talked about how the organization has successfully used SharePoint as the focal point for enabling its members to collaborate on a array of projects and the organization's transition to Microsoft Office SharePoint Server 2007.

What groups in your organization use SharePoint, and how are they using it?
We have about 40 internal users, staff people with our organization, and probably another 100 remote users, volunteers in the community whom we work with very closely. We have approximately 10 SharePoint sites, which include our internal staff intranet and nine extranets. Most of our extranet sites include users from both nonprofit and for-profit organizations who are volunteers.

One of the extranets is our Boardnet site, which we've had in place for two years and is used exclusively by our 11-member board of directors. They use the site to share reports, proposals, calendars, and other information. For instance, a couple weeks prior to our monthly board meetings, we distribute all pending documents that need to go through an approval process on the Boardnet site, so that our board members can review the documents and pre-vote on those proposals before the meeting. They can schedule additional discussion about those proposals for the meeting, if needed.

The other eight sites are dedicated to specific projects, initiatives, and project teams that we coordinate. Typically a couple of our staff members are project managers, and they coordinate volunteers who work on related projects. These groups have a significant need for sharing documents and calendars of events and discussion groups. We found that using the SharePoint site is a much more efficient means of collaborating with offsite individuals who are participants in these important projects than phone calls and sending out emails with attachments.

You probably anticipated that having an online document-review process prior to board meetings would make those meetings much more efficient. Is that what actually happened?
Absolutely, that was the objective. We wanted to make our meetings and discussions as efficient as possible, and making certain proposals and research documents available to members a couple weeks before the meeting allowed them time to research and review proposals, generate questions, and vote on the proposals And the meetings have indeed been more effective and efficient.

You're in the process of implementing SharePoint Server 2007. What new features do you expect will improve your employees' and volunteers' ability to collaborate?
The new search capability is one of the most significant features for us. We're in the process of configuring it now. The search feature is very comprehensive and allows you to design and customize searches and search scopes. Especially important for us is that it lets you search the company's network drives as well as SharePoint sites. Information \[that's saved on the network\] sometimes ends up being related to either a project, a customer, or a particular time period; saving that information in an organized way is a challenge. Having a search that will look through a network drive, go through the index, and retrieve saved files or messages is a powerful capability. We're testing the SharePoint search engine right now and, from what I can see, the indexing is dramatically improved over that in previous Microsoft products. In our testing so far, we've found that the network-drive search is very quick. We'll be deploying the search feature soon.

You're also planning to use SharePoint 2007's Microsoft Excel Services integration—for example, by using dashboards and Key Performance Indicators (KPIs). How's that going?
Dashboards are a means of graphically reporting on an organization's critical success factors (KPIs). They're an effective way to present summary information from Excel spreadsheets about the performance of projects or the organization to management via a SharePoint site. Using dashboards, management will monitor numbers of donors, new donors, new gifts, new funds, and impact trends. We want to track and present that information on dashboards. Getting the dashboards operational has been a little challenging, mainly because we're still learning how to use the new features. We're now defining critical information to be presented on the dashboard.