Calculated Columns showing URLs

I keep forgetting how I did this and having to dig into old demo VMs – you can display hyperlinks via calculated columns:

Calculated URLs to Search Results page

Yup, the AnimalName column is calculated, and consists of a URL and a search term which is the item’s title:

Calculated Column Configuration

Although it doesn’t show it, [ID] is also a valid column to insert.

Sadly, I’ve not figured out how to display a ‘pretty’ calculated column yet – for example one that just showed ‘Click me‘ rather than the full URL. Still, I thought that having a link to search was interesting. And naturally, if you use the DataView web part then setting up the link with a ‘pretty’ link is trivial.

Calculated Columns showing URLs

Automatic incrementing IDs

Neat tip from the SharePoint UK User Group (and thank you Dave Hunter) – if you want an automatic, incrementing column on a list…

Create a new calculated column, with =TEXT(ID,”000000″) as the formula and return data type a single line of text. It will give you 000001.

Neat. I didn’t know that ID was a valid command in a calculated column.

Automatic incrementing IDs