-
SharePoint 2007 - Calculated Fields
-
I was reading thru some blogs, namely that of Kevin DeRudder, today. He recently posted some information on calculated fields. I get questions pretty often from clients on the available formulas when creating a calculated field. In his post, Kevin talks about how to reference a yes/no field from a formula inside a calculated field.
I just wanted to expand on his post a little and post this link to Examples of common formulas on the Microsoft Office Online site. I frequently complain about the lack of documentation when it comes to SharePoint, but it seems someone had the time this time around and has documented a good deal of the formulas available for calculated fields.
Everything from Conditional Formulas, Date and time formulas, Math formulas, Text formulas and a few others are documented quite nicely.
There is even a page that talks about the Calculation operators. This includes the "Types of operators" available and "The order in which a list performs operations in a formula".
I hope you find this page as useful as I did.
-
What does it take to be an SharePoint expert?
-
As a SharePoint SME, I tend to get odd looks sometimes from people who clearly have no idea of all that is involved in the technology, let alone being a subject matter expert. Most people think it's point and click and I have to say, that drives me batty. I'm not sure what fosters this perception, but it's out there. Joel Oleson has an excellent blog post that lists a pretty good set of skills that we are are required to have extensive knowledge of to be good at what we do. His list does not include any dev skills, so go ahead and add those in for an even more well rounded SME.
Joel's list is here.
Now no more funny looks, ok?
-
Using the Save site as template link on a publishing site
-
A colleague recently asked me if there was a way to save a publishing site as a template recently. I responded by informing them that the "Save site as template" link is on the Site Settings page under Look and Feel. He said it was not. After a quick investigation, I realized that it is in fact not there; see below...
Blank Team Site
Collaboration Portal (Publishing)
The easy solution that seemed to work, and I leave you with the caveat that I have not fully tested this solution, is to simply determine what page this link goes to on a Team site, namely savetmpl.aspx, and type that into the location bar of your publishing site. The "Save site as template" page then appears and you are able to save your publishing site as a template.
Blank Team Site
Collaboration Portal (Publishing)
I am not sure why they removed this link on the publishing enabled sites, but I am certain there must be a perfectly good reason; maybe there are some things that happen in a publishing site that you simply cannot store in a template. If anyone is aware of the reasons or has seen them documented somewhere, please do let me know.
-
I'm an MVP now!
-
I am very happy and humbled to say that Microsoft has chosen to award me an MVP for Windows Server - Windows SharePoint Services. I'll take this chance to thank some of the people who have helped me over the years, including Stacy Draper, Matt Ranlett, Keith Rome, Brendon Schwartz, Jim Wooley and last but not least by any stretch of the imagination, Doug Turnure. Without these people and any others I may have not mentioned (not on purpose), I may not be blogging this post today!
Thanks everyone and here's to a great year ahead!