Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Calculated column - problem with formula

  Asked By: Steve    Date: Nov 06    Category: MOSS    Views: 1941

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"?

Share: 

 

No Answers Found. Be the First, To Post Answer.

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




Tagged: