I would like to share my experience in creating Custom Calculated URL column. My objective is to construct a URL from custom calculated column. Hopefully this might save some time for others cause I’ve spent a bit of time to Google it and found this article, but unfortunately it does not work in SharePoint 2010 and 2013.
While trying some silly thing, I ends up making it work and I should also reported it to Microsoft (because it looks like a bug). For now, I wouldn’t bother and as long as it works … =)
- Create a SharePoint list that looks like below:
- Create calculated column for URL. I would like to add calculate URL column “CaseURL” that has formula “http://site/web/Pages/Case.aspx?caseno=[CaseNo]“. So, users can click the link and go to Case.aspx page with URL parameter passed. Instead of selecting “Single line of Text” as the data type returned from this formula, try to select “Number” or “Currency” or “Date and Time“. Then click OK to create the column.
- Done and we can test it.