Nested if statements in calculated columns

Assuming that you have a column called severity and likelihood and you've multiplied them together in column called risk score:

=IF([Risk Score]<=3,"Low",IF([Risk Score]=9,"High","Medium"))

should work out what is a high medium and low risk. The post below this, from endusersharepoint.com is fine and lays out in excruiting detail all that is necessary to do anything with calculated columns. However the above solution for nesting columns looks easier on the eye, and mind or at least my eye and mind and sort of explain itself really.

Good and helpful small scale sharepoint solutions

This seems to be a sharePoint site for beautiful people who demand beautiful sharePoint sites with bijou SharePoint fixes and how to's - what's not to love: http://www.endusersharepoint.com. It says its not geeky but it is a little bit.

Using [Today] inside a calculated column

Well there is a bit of a problem is that you can't - not really though this looks like it does the trick
http://blog.gemsolution.co.uk/2008/01/05/calculated-column-using-today/.
BUT the big problem is this

"the formula will not calculate all list items on refresh but rather by the addition and deletion of a new Today column or by editing each of the list items individually."

So this formula - pretty though it is won't cut the musturd

IF(TEXT(Today,"mmm yyyy")=TEXT([Meeting Date],"mmm yyy"),"Yes","No")

nor can you use this to organize items in a list or library by year by using this formula http://glorix.blogspot.com/2007/07/filter-by-year.html

But to the rescue comes pathtosharepoint

http://pathtosharepoint.wordpress.com/2008/11/24/countdowns-a-second-method/

B

Sharepoint backup and restores up and down from the item level http://www.avepoint.com/products/sharepoint-administration/sharepoint-administrator

A handy list of things you can't do in sharepoint but which an inexpensive bamboo web part makes easy.

If you need to create one to many relations between lists

Integrity Roll up up

If you need to aggregate many lists across sites

Cross List Web part

To create bespoke alerts

Alert Plus

C

Need to delete a content type but get the error "content in use" well you need to find where it is in use ... try this http://blog.tylerholmes.com/2008/02/deleting-content-types-in-sharepoint.html

CAML query builder so useful http://www.u2u.info/SharePoint/U2U%20Community%20Tools/Forms/AllItems.aspx developed by Patrick Tisseghem