Thursday, August 02, 2012 2:14 PM
Using WSS 3.0 SP2
I have created a calendar to track our server patch schedule. I have a choice column called Operating System. Available values are Linux, OSx, Unix, and Windows.
I would like to create a calculated field that does the following:
If choice column Operating System displays Windows, that populate calculated field with Windows1, Windows2, Windows3.
If choice column Operating System displays Linuxt populate calculated field with Linux1, Linux2, etc.
Can I do this without modifying the source? Any help will be highly appreciated. Thank you in advance!
Friday, August 03, 2012 3:06 AMModerator
We can use IF function in the calculated formula:
=IF([Operating System]="Linux","Linux1, Linux2",IF([Operating System]="Windows","Windows1, Windows2, Windows3",""))
For more available formulas in calculated column, please see this reference.
Let me know if you have any question.
Thanks & Regards,
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact email@example.com.
TechNet Community Support
- Marked As Answer by mh53j_fe Friday, August 03, 2012 11:20 AM