How To Create Calculated Columns On SharePoint Online

This blog is about how to create Calculated Field on SharePoint Online or any other version.

SharePoint Calculated Columns are powerful tools when creating out-of-the-box solutions. These options or columns can manipulate other columns in the list item, like we can integrate one column with another and show as a result more in  the calculated columns.

I am just showing you a simple example to do so.

  • To create simple calculated columns, go to the "List Settings" page.

  • Open List, select List Ribbon from top of the page and select List Settings.

  • We need to make sure that we have existing columns which we are going to use in calculated columns. If it does not exist, we can add fields. For example, I am creating two number type columns for additional calculated columns.

  • To add new columns, just go to List settings, add columns section, and add new field. In my case, I am adding two columns. Given below are the screenshots for the same.



  • Once both the above fields are added, we will go ahead and create new calculated columns.

  • Just create new columns and select type as calculated below.

  • After selecting calculated type, it will redirect the same page to the formula. Here, add your operator and select columns from the right side to function the same.

  • Once you're all done, click on "Create". Below are the full page screenshots for the same.



  • Now, go back to the List and see the result after adding data to the respective columns.

Thanks.