Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculated Column

Status
Not open for further replies.
sardine53

sardine53

Programmer
Jul 4, 2003
79
US
Hello,

We are using MOSS 2007

I have a list and would like to create Choice columns that only show choices based on another columns data:

Example:
Column 1 Column 2
ClassType Class
PPE Eye
PPE Hand
PPE Hearing
Driving Accidents
Driving Defensive

If Column 1 = PPE then the Choices available in Column 2 are (Eye, Hand, Hearing)
If Column 1 = Driving then the Choices available in Column 2 are (Accident, Defensive)

Is this possible with a Calculated Column? If so, what is the formula.

Thanks in advance for any assistance!
 
Status
Not open for further replies.

Similar threads

Erichss
  • Locked
  • Question
Sharepoint Column Formatting Assistance
Replies
0
Views
591
Erichss
Erichss
akrshaw
  • Locked
  • Question
List Calculated Column - Count Text
Replies
1
Views
109
ehaze
ehaze
shelby101
  • Locked
  • Question
SP2013 Calculation columns in a library
Replies
1
Views
194
shelby101
shelby101
MikeBlair
  • Locked
  • Question
Fixed column widths in web part
Replies
0
Views
88
MikeBlair
MikeBlair
Skooshie
  • Locked
  • Question
Calculated Column Formula
Replies
0
Views
46
Skooshie
Skooshie

Part and Inventory Search

Sponsor

Back
Top