Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Field Functions

  Asked By: Jayshree    Date: May 15    Category: Sharepoint    Views: 6889

=TEXT([Created], "mmmm") (October)

Are the functions that sharepoint uses in calculated fields SQL
functions? Excel Functions? VB functions?

Where is the documentation for supported functions so I don't get the

The formula contains a syntax error or is not supported.



14 Answers Found

Answer #1    Answered By: Brianna Olson     Answered On: May 15

They are basically Excel functions.

Answer #2    Answered By: Allyson Burgess     Answered On: May 15

Very good question and something I've wondered. Many Google and Live searches
have turned up nothing of use to me on this.

Answer #3    Answered By: Anila Bhuva     Answered On: May 15

The only real documentation  I've come across is this:


Answer #4    Answered By: Elaine Mack     Answered On: May 15

that is a great start.... thanks for the info.

Answer #5    Answered By: Baiju Hoskeri     Answered On: May 15

That site is really hard to navigate but I found this link too. I'm not
sure how close in context it is to the other one. Like I said, the
parent site is a little hard to navigate.


Thanks everyone for your feedback on this topic. This really is huge.

Answer #6    Answered By: Kristy Hicks     Answered On: May 15

Ok, I have a specific question regarding the use of these functions. I have a
user that has a big need to have a unique number generated for each document
that is inserted in to a Doc Lib. I can't seem to figure out how to expose the
underlying ID field  that MOSS stores in the DB such that I could create a
Calculated Field and reference that number or do something where I take the
number and add 1 each time.... has anyone been able to do this using the tools
available??? This would be huge for us.

Answer #7    Answered By: Amanda Brown     Answered On: May 15

I've never seen a way to do this using the user interface or SharePoint
Designer. I think you would have to do it with either an event handler
or by building a custom field  type. Either way I suspect you will need
to use programming to create a solution.

Answer #8    Answered By: Carey Everett     Answered On: May 15

This may be too simplistic, but have you tried adding the OOB id
field to the view? It's just a simple counter field, but does seem to
work in cases where we've needed simple document ID functionality.
(Yes, I just used the word "simple" three times in two sentences.)

Answer #9    Answered By: Anuj Lakhe     Answered On: May 15

I thought about that, but that only works on a per-list basis. I'm looking for
something to leverage the DB's ID because I need that unique document number. I
appreciate any feedback as I need to solve this.

Answer #10    Answered By: Lee Dickerson     Answered On: May 15

I am wanting to set a unique document ID in a calculated  column. I did
try doing this by concatenating a string (representing the site and
library) and the document's ID number.

eg I used a formula  like ="STD001-X-"&text(ID,"0000")

The text function was to insert leading zeros.

I thought this was working but it only worked for existing documents.
For any new documents the result is "STD001-X-0000". I suspect this
may be because the ID number is not determined until the document is
saved and so at the time of the calculation it is null.

Does anyone have any suggestions on how to make this work or a
statisfactory alternative for a simple unique ID for each document?
This is for a records management environment using MOSS.

Answer #11    Answered By: Aditiya Kapale     Answered On: May 15

We used a combination of the path/queue name and the ID for the document,
that combination should always be unique.

Answer #12    Answered By: Cristopher Gould     Answered On: May 15

You could do this using a simple SharePoint Designer workflow. ID is available
at that point.

Answer #13    Answered By: Selena Glenn     Answered On: May 15

If you want an ID that is unique throughout your farm deployment then I suggest
you create your own database with a table to store the IDs, add a OurOwnUniqueID
Column to all lists.libraries, and use onadding eventhandlers that get the next
ID from the DB and assign it to the OurUniqueID Column as appropriate.

Answer #14    Answered By: Jonathon Palmer     Answered On: May 15

I think I may have found another code-less solution. I created a custom column
(RefNo) and I am doing the following.


This is definitely closer to where I want to be except that I have to hard code
the Doc Lib name as you can see by the first argument in the function. I would
like to reference the current library somehow, and perhaps even the web name or
something else. Any thoughts on how I might be able to reference the current
Library or the current website?

Didn't find what you were looking for? Find more on Calculated Field Functions Or get search suggestion and latest updates.