Blogging about SharePoint

12/19/2007

Found! Function Reference for Calculated Value Fields

Ah ha! One of my friends pointed me to this help file that has a list of functions supported by Calculated Value Fields.

It's a .CHM file located at C:\Program Files\Microsoft Office\Office12\1033\STSLIST.CHM on client machines that have Office 2007 (possibly Access 2007 in particular) installed.

The "normal" way to get to this file is to open a list – almost any list – and change to the Datasheet view. Then expand the left hand menu and click on the Help icon. The file that pops up is STSList.CHM, its title is "Access Web Datasheet Help" and the root topic is "Office List Datasheet View 2007". Look for the Function Reference subtopic.

Thanks also to the FileMon utility from SysInternals for helping me track down the actual CHM file.

--Michael

PS, this is a follow up to my previous post, "What, no WEEKNUM()?".

Posted at 4:20 PM by Michael Blumenthal | Category: SharePoint – WSS and MOSS | Permalink | Email this Post | Comments (0)

Comments

There are no comments yet for this post.

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title

Body *

Please put your name at the end of your comment as the Name field doesn't display in the main view of the comments.

Name: *

Your name. If you first name is Michael, please provide initials or the like to clearly distinguish your name from Michael Blumenthal's.
Also, this field does not appear in the main view of the comments.

Need Paid Consulting Services?

Yes

Are you interested in engaging a SharePoint consultant for fee-based consulting services? If so, I can have an Account Executive from my employer contact you. Other site visitors will not see this column.

Additional Contact Information

Please provide additional contact information if you need a direct response. Other site visitors will not see this column.

What is tomorrow's date? *

This is a weak CAPTCHA based on advice from a tweet from @ToddKlindt.

Attachments