Add Various Calculated with airSlate SignNow

Create teams, Add calculated fields and Sign

[Music] hello this is greg from sharepoint maven and in today's video i would like to explain to you how you can create a calculated column on the sharepoint list the library so we can actually create lots of different metadata columns different types of columns in sharepoint if you hover over the add column um you know drop down we we can create different types of columns we can create a text column and location number date and time drop down you know choice column currency etc one of the columns we can also create it's called calculated column it's not on this list we kind of have to go behind the scenes to create it so it might not be obvious but we can create this as well so first of all what is the calculated column a calculated column is essentially a column that is referencing other columns it's a column that is based on mathematical formula and what you can do you can pretty much you know create formulas and reference other columns uh within your list of library to calculate a new value for that column so uh for the first example i would like to show you i would like to give you two examples for the first one uh we're going to do something really simple so i have this library of company policies with a few pieces of metadata one of them is the expiration date all right and what i want to do is create another column that will calculate the expiration reminder date which will be 30 days prior to this date so essentially it's going to be expiration date minus 30. all right so let's go ahead let's go ahead and create one so add a column again we need to click more because we need to go behind the scenes to create it and here we go we are going to give it a name um here we go [Music] perfect now we have to choose this calculated radio button over here again it's not available on kind of on the previous screen and when you do that you will see this field over here this is where the formula goes now if you know the syntax you can you know start typing it in but you can also um you know we have this other portion where we can actually choose the existing columns we can reference so the formula again is expiration date minus 30 all right so it's 30 days prior to expiration date so i'm going to double click here and then minus 30. perfect all right so and then the only other thing we need to do is over here we need to select the proper type of the output in our case we are calculating you know the new date field so that's exactly what we're going to choose here we go and let's click okay let's see what happens here we...