SharePoint Online: Update Calculated Field Formula using PowerShell

How to Update the Calculated Column Formula in SharePoint Online? Calculated columns in SharePoint allow you to perform calculations on other columns within a list or library. They can be used to automatically calculate values based on data entered in other columns or perform more complex calculations involving multiple columns. SharePoint supports…

Read more

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 are used to manipulate other columns in the list item. Instead of being entered by a user, these field values are automatically calculated based on the formula. Calculated fields will…

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 the 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. The same code can be used for List level formulas as well. PowerShell…

Read more

How to Add Calculated Column to SharePoint List using PowerShell?

Requirement: Add a new calculated field to SharePoint list programmatically using PowerShell script. PowerShell to add a calculated column in SharePoint list or library: Here is how to add a calculated column to your SharePoint list using PowerShell. Script in action: Create calculated column in SharePoint 2013 using PowerShell

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

Format 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