I have a custom list definition to track Work Priorities. One of the required fields is 'Status' which is a dropdown choice of Red, Green, Amber, or Black. I created a computed field 'Ranking' that is based on 'Status' Here is the code:
=IF(Status="Red",1,IF(Status="Black",2,IF(Status="Amber",3,IF(Status="Green",4))))
I use this to Sort in a view. This list is in development right now but once the final version has been approbved, I will create a custom list definition to apply to all our team sites.
My question is how do I create this computed field in a custom definition?
Do you know someone who can help? Share a link to this thread on twitter, or facebook.