SharePoint
SharePoint/SPO

How to create calculated column in SharePoint List/Library?

In my previous post, where i have explained “What is a calculated column in SharePoint?” and now i will show how calculated column will be created in SharePoint List/Library.

Steps-

  • Go to your SharePoint List/Library.
  • Click on +Add column then Click on more.. This will redirect to a create column page.

CalculatedColumn

  • Click on List/Library setting then click on create column link which will also show you create column page.

CalculatedColumn

CalculatedColumn

In the above page Formula field is most important part of calculated column. You need to add logic and columns from the side panel in your formula to calculate value and then set return type your calculated column value. Return type should be selected very carefully as this will impact your calculated value.

OutPut of my calculated Column –

CalculatedColumn

In the Next Article i will cover some important formulas for calculated column.

Thank you

-Gopenly

Leave a Reply