Two tips for calculated columns

You may have noticed that I am using calculated columns a lot these days… Well, I found a nice tip here:
http://blogs.officezealot.com/legault/archive/2008/02/14/20846.aspx

The datasheet view allows you to directly edit formulas, and also provides context help on the SharePoint functions.
Thanks Eric!

Here is another tip I got from Per Jakobsen on the Microsoft discussion groups: to include double quotes in a formula, use double double quotes. For example:
=[First Name]&” says””hello!”””
This is very useful for me. As I am using calculated columns to write HTML, I had the need to include double quotes in the formula itself. Here is an example (pretty much useless, I know, but I plan to do better in future posts :-)):
=”<DIV onmouseover=’alert(“”hello!””)’>”&[First Name]&”</DIV>”

Advertisements