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.
![]()
![]()
Thanks.