Search: | |||||

| ||||

Home » Forum » MOSS | RSS Feeds |

I have 7 columns in a Sharepoint list:

MS0

MS1

MS2

MS3

MS4

MS5

MS6

These columns may or may not contain a date depending on which "Milestone" the project is at. So, if MileStone 0 is reached it will contain a date of when it was reached. If Milestone 1 is not yet reached, it will contain a blank value and so will every subsequent milestone

I need to create a calculated column which defines a "Project Status"

If MS0 contains a date, the Project Status = Starting

If MS1, 2 or 3 contains a date, the Project Status = Planned

If MS4 or 5 contains a date, the Project Status = Active

If MS6 contains a date, the Project Status = Closed

How do I express this as a formula in my calculated column "Project Status"?

Didn't find what you were looking for?
Find more on Calculated column - problem with formula
Or get search suggestion and latest updates.

Related Topics:

- Excel Formula in SharePoint Calculated Field/Column
- Calculated Column using =LEFT() formula
- Calculated column formula
- Problems searching in a calculated column in a data view web part
- Calculated column problem
- Setting the formula of a calculated field using the Object Model
- How can I build a longer (7>)calculated formula using the =IF function
- Column IF formulas only nest seven deep.
- Calculated Column Output HTML
- Calculated Column Begin Event List
- Calculated Columns in Lists
- Using the file namd in a calculated column
- More on calculated columns
- How do I calculate column averages?
- Calculated Fields and the ID Column
- Trying to create a sign-up list using calculated columns
- Item ID in Calculated Columns
- Calculated Column Formatting
- Field is not available in selection box for calculated column
- Calculated Columns - Creating a site template
- Calculated column question
- Calculated column only updates when list item is edited
- Calculated Columns - Between lists
- Calculated column not showing up in VIEWS Totals
- Using calculated columns in content types