Free Material

Create Calculated Value Column in SharePoint List

02 April 2024

In today's article I will show you how to create calculated values columns in a list in SharePoint Online First we need to select the site where we will create a list on which we will create custom columns and then a custom column which will be of the type calculated values We select the site where we want to create the list and then from the gear in the top right select site contents

Then we select new - List

In the next step I select blank list

And I give a name to my new list and a description

I select Add Column and choose it to be a number

In the next step I need to give a name to my new custom column, and I name it number 01 so that I can later add its value together with the value from another column to a new type of calculated value column

I create another custom column called Number 02

Now we have to create a third calculated column again and name it sum

In the formula field I need to enter the two columns where I want the addition of the values of each item to take place, as shown below, as well as specify the type of data I expect to be returned to this column

I create a new item where in the first column I put 4 and in the second column I put 5 and in the sum column I expect to return the addition of these 2 which is 9

Indeed after creation in the sum column 9 appears

#ModerWork #M365_Apps_Services #BusinessApps #SharePoint #technology #microsoft #digitaltransformation #cloud #mvpbuzz #m365