Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using formulas in sharepoint

  Asked By: Rachelle    Date: May 03    Category: Sharepoint    Views: 5862

I am brand new to using formulas in SharePoint. First question is what
language is the formula written in? Next question is how would I write a
formula to fill in a field called "Completed date" that looks at a
field [status] and uses the current date if the status is "06-Complete".
The following is what I tried, but again it is just a shot in the dark.

If [status]="06-Complete" then {Completed date]=current



2 Answers Found

Answer #1    Answered By: Mayur Mandal     Answered On: May 03

The functions look (to me) a lot like XPath, but I'm at a loss to put a
name on them. You can find an overview and a complete function list,
respectively, at the following locations:


Function List:

As you will discover, the "if" condition isn't quite what you'd expect
as a .NET developer. There's actually a function that performs a test and
returns one of two parameters based on the result of the test; you can read
the explanation of the IF function at the following location:


Answer #2    Answered By: Deana Lowery     Answered On: May 03

I was able to get the function working
as desired.

Didn't find what you were looking for? Find more on Using formulas in sharepoint Or get search suggestion and latest updates.