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.