Calculated Columns in a Calendar

Question

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!

Answer 1

Hi mh53j_fe,

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.
http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx

Let me know if you have any question.

Thanks & Regards,
Emir Liu
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact [e-mail].

---

Emir Liu

TechNet Community Support