Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using formulas in sharepoint

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

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

Share: 

 

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:

Summary:
office.microsoft.com/.../CH011711541033.aspx

Function List:
office.microsoft.com/.../CH011711171033.aspx

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:

office.microsoft.com/.../HA011610101033.aspx

 
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.




Tagged: