Wednesday 8 February 2017

How to create calculated columns on SharePoint online

This Blog is about How to create Calculated Field on SharePoint online or SharePoint any other version.
SharePoint Calculated Columns are powerful tools when creating out-of-the-box solutions, these option or columns can manipulate other columns in the list item. Like we can integrate one columns with other and show as result there is more inn calculation of columns.
I am just showing you a simple example to do so for:
  • To create simple calculated columns, go to the List setting page.
  • Open List select List Ribbon from top of the page and select List Settings
  • We need to make sure we have existed columns which we are going to use in calculated columns, If it is not exist we can add fields. For example I am creating tow number type columns for additional calculated columns.
  • To add new columns, just go to List setting and add columns section and add new filed, In my case I am adding two columns below are the screen shots for the same:

  • Once both above filed is added, we will go ahead and create new calculated columns.
  • Just create new columns and select type as calculated shown below screen shot:
  • After selecting calculated type it will redirect same page to formula, here add your operator and select columns from right side to functioning the same.
  • Once all done click on create. Below are the full page screen shot for the same
  • Now go back to the List and see result after adding data to respecting columns:

Thanks ☺

1 comment:

  1. Hashstudioz Technologies brings you the Machine Learning technology based development that enhances your business services and provides with optimal solutions. get the eading Machine Learning Developments., Blockchain , Salesforce , Mobile and Web.

    ReplyDelete