Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

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

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

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.

Related Topics:

- How can I build a longer (7>)calculated formula using the =IF function
- Setting the formula of a calculated field using the Object Model
- Calculated Column using =LEFT() formula
- Excel Formula in SharePoint Calculated Field/Column
- No Formula Bar in Excel Web Part
- Calculated column - problem with formula
- 'The formula contains a syntax error or is not supported' Error
- Conditional Logic in Infopath formula controls
- Need help writing a formula for WSS 3.0
- Help with WSS 3.0 formulas
- Filter formula in a doc lib. view
- Column IF formulas only nest seven deep.
- Excel Formulas
- Formulas and calcualtions
- Formulas and calculations
- Formulas for Lookup
- xsl formula not working right
- Convert excel formula to xsl for use in data form web part
- Formula
- Calculated column formula
- Filter formula in a doc lib. view
- Security within sharepoint object model used outside of sharepoint
- Using PSconfig to Deploy using DBA-created databases MOSS 2007 error
- Retrive Sharepoint List Items using List ID --Developement in SharePoint 2010
- Display Current Logged in user in Sharepoint list column (we are using FBA-Claims based auth