SharePoint Online: Format Calculated Column as Hyperlink

Requirement: Format Calculated Column markup as Hyperlink. How to Format Calculated Column as Link using HTML Markup? Using calculated column formulas to frame hyperlinks and setting the column type to “Number” renders the column markup as HTML. E.g. I’ve used this formula to link project documents with the Projects list. Well, not…

Read more

SharePoint Online: Add Calculated Column to List using PowerShell

Requirement: Add Calculated Column to SharePoint Online List How to Add Calculated Column to SharePoint Online List? Calculated columns in SharePoint Online is used to manipulate other columns in the list item. Instead of entered by a user, these field values are automatically calculated based on the formula. Calculated fields will not…

Read more

Update Calculated Column Formula in SharePoint List using PowerShell

Requirement: Update a Calculated Field’s formula for a specific column of a list across entire site collection. PowerShell to update calculated field formula in SharePoint: This updates the site column’s formula for all subsites in the site collection. Same code can be used for List level formulas as well. PowerShell to Update…

Read more

SharePoint Links List Open in New Window

I explored various methods to make the SharePoint link list to open in a new window at SharePoint Link list: Open in a New Window, while the methods discussed in the article are applicable for SharePoint 2013 too, there is one more: using calculated columns! Let’s drill down in detail with SharePoint…

Read more

SharePoint Number Column without Commas

Problem: SharePoint Number columns shows, (comma) in View/Display Forms. There are specific numeric columns, User wanted to display without commas. There is no direct way to remove comma/avoid thousand separators in SharePoint Number fields, But the below tricks help to get SharePoint 2007/2010/2013 number column values without commas. Solutions: Here are some…

Read more

KPI Dashboard using SharePoint List

We can generate the KPI list using simple SharePoint list with computed columns! Here is how we can get SharePoint list based status indicator. Create a SharePoint list with desired fields, then create a field with choices, Let’s say, Field name Cost_Input: with values Red, Green, Blue. Then let’s create another computed…

Read more