Bug in Editing Sharepoint Organization Profiles

There appears to be a bug in editing Sharepoint 2010 Organization Profiles. If you try to edit the Profile SubType without editing any other field your change is not saved. The work around is to update any other field at the same time (and then don’t forget to change that field back).

Refer to the comments on MSDN http://msdn.microsoft.com/en-us/library/ms545122.aspx for an example on how to do this in code.

Sharepoint 2007 Calculated Fields

This is just a quick brain dump of some research into Calculated Field formulas for MOSS that i’ve had sitting as a Draft for a while.

• The most official resource appears to be:
  http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx
  Which i discovered via:
  http://www.devcow.com/blogs/jdattis/archive/2007/07/30/6719.aspx
  Unfortunately it doesn’t appear to be complete, for example it is missing the ISBLANK function.
• There is also an MSDN Reference:
  http://msdn.microsoft.com/en-us/library/bb862071%28office.12%29.aspx
• An interesting guide on testing forumlas using Excel:
  http://techtrainingnotes.blogspot.com/2010/08/sharepoint-creating-calculated-column.html

UPDATE: This appears to be the most comprehensive offical guide on Formulas and Functions that can be used:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH010065006.aspx