Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

I have created a calculated field and need some help.

calculated Field name GateDate, Time, what I am trying to achieve is if BD

Status = "Qualified Gate 1" and Gate2 Rvw has a date then Gate2 Rvw, ""

I am getting a date of 12/26/1899 in some fields and I think I need to somehow

in my formula say if Gate1 Rvw ="","" (the Gate1 Rvw, Gate2 Rvw, Gate3 Rvw,

Gate4 Rvw are date fields)

=IF([BD Status]="","",IF([BD Status]="Qualified Gate 1",[Gate1 Rvw],IF([BD

Status]="Qualified Gate 2",[Gate2 Rvw],IF([BD Status]="Qualified Gate 3",[Gate3

Rvw],IF([BD Status]="Qualified Gate 4",[Gate4 Rvw],"")))))

I'd like to help, but I'm not entirely sure what you're after here.

Could you spell out your logic a bit more explicitly in regular-people

language?

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

Related Topics:

- 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
- Setting the formula of a calculated field using the Object Model
- Help with WSS 3.0 formulas
- Using formulas in sharepoint
- How can I build a longer (7>)calculated formula using the =IF function
- xsl formula not working right
- Convert excel formula to xsl for use in data form web part
- Calculated column formula
- Filter formula in a doc lib. view
- Conditional Logic in Infopath formula controls
- Need help writing a formula for WSS 3.0
- Calculated Column using =LEFT() formula
- No Formula Bar in Excel Web Part
- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- 'The formula contains a syntax error or is not supported' Error
- Unable to update a the default formula of a calculated field?