Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulae. They allow you display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

1
vote
1answer
23 views

Calculated Column Next Year in Text Format - (Sharepoint 2013 on Prem)

I have a calculated field [Current Year] in Text Format: =TEXT(Created,"YYYY") which displays "2019" in Text Format. But I also want to create a new Column with a calculated column that is next ...
0
votes
1answer
10 views

Using Excel AVERAGEIF in a Calculated field

Using this statement =AVERAGEIF(B2:B13,"<>0") found here: https://www.extendoffice.com/documents/excel/1573-excel-average-ignore-zero.html My calculated SharePoint field would be this: =AVERAGEIF(...
1
vote
0answers
44 views

SharePoint 2010 - Calculated column - IF statement with (OR) not working

I have the following entered as formula in a Calculated column (returns single line of text)... I'm going to add to the formula, but it's stuck on this point; takes me to error page: =IF( OR( LEFT([...
0
votes
1answer
17 views

Set date column default for specific time on day

I have a date and time column in a SharePoint document library Is it possible for the default value to be a certain time (e.g. 1pm) on the day of creation?
0
votes
0answers
11 views

Adding a sum column which uses data from lookup

I have a list with employee names and a lookup column from another list, which has the training names and training duration. The training duration is added as an "additional field" from the lookup ...
0
votes
1answer
16 views

How to calculate the third Monday of the month an item is created using a calculated column (date / time)?

How to calculate the third Monday of the month an item is created using a calculated column (date / time)? I wish to calculate the date based on the created column.
0
votes
1answer
16 views

Difference between dates in two last items form the same order

I tried to look for the answer in the forum and google, but with no success. I have a list: let's say: 'Site ID','Date requested' 11111, 2019-03-05 11110, 2019-03-15 11111, 2019-05-01 I want to ...
0
votes
2answers
33 views

Calculated formula not showing correct behavior

I have a calculated column called DaysDifference which calculates days difference between two date fields: [Due Date]- [DateToday], I am updating datetoday field everyday using Flow to set it to ...
0
votes
1answer
33 views

Title and date in a calculated column (SharePoint Online)

I need to create a calculated column with the value from the Title column and the date part from a Date & Time column, separated by a space and the date format like YYYY-MM-DD. Something like ...
0
votes
3answers
34 views

Unable to calculate field value from conditional formula

trying to find solution for calculation of rates. The data type returned from this formula is number. if ([Role]="​Senior Software Engineer", "200", if ([Role]="​Senior Technical Consultant", "400", ...
0
votes
0answers
6 views

Calculate “Days Since” a specified date

Good Afternoon I am using Sharepoint 2013 OP with SPD 2013. I want to create an element on my SP site which calculates how many days have elapsed since our last accident. For Health and Safety ...
0
votes
0answers
31 views

SharePoint Online : Help to Update Calculated Column in a List on a daily basis

I have a list in SharePoint Online environment where I need to calculate DaysLeft using 'Expiry Date' Field - Today() in a calculated column. The calculated field is not updating on a daily basis. ...
0
votes
1answer
31 views

Is it possible to dynamically refresh a calculated field on the Edit form when a connected field is changed?

On the Edit form, I am trying to dynamically have a calculated field show updated values when the connected field is changed. The idea is to give the user more details on the selected week. Is this ...
0
votes
1answer
32 views

sharepoint 2013 library calculated column

I want to create calculated column in SharePoint library, but get error here is error that I got and also here is column Can someone tell me what I have done by mistake?
0
votes
1answer
29 views

IF OR Syntax in SharePoint

I need help adding some logic to my syntax. Current formula is set to the following value and it works perfectly: =IF(AAA<>"","Closed",IF([BBB]<>"","Pending Approval","Pending Review")) ...
0
votes
1answer
28 views

Need help on calculated column formula for below requirement

I am using OOTB SharePoint Task List. Due Date column has date values tagged for each of the tasks. I am trying to add a calculated column which should be set to Valid if following two conditions are ...
0
votes
2answers
54 views

Background color on column

I am not a SharePoint guru and I don't know much about coding. I have a list which I would like to change the background color of the cell or row based on the Priorities ( (1) Critical, (2) High, (3) ...
1
vote
1answer
47 views

Calculated Column 48 hours due date weekday

I am trying to generate a simple calculated column formula for a 48 hours email alert considering weekdays only. No weekends. New at this. Any ideas.
0
votes
2answers
51 views

SharePoint Calculatted column

I need to create a calculated column to get the number 7261 from the string below. Sometimes it can be 4 digits, sometimes 5, so cant use exact character count. I tried to use the FIND option and ...
0
votes
0answers
29 views

Workflow and columns set up for calculation

In a list that we use as ticketing tool, I have a field where I have to input my working hours every time. I'm looking for a way in which I can just input a number in that field but also have another ...
0
votes
1answer
36 views

Calculated Columns with Conditions

I have found plenty of posts that mentioned how to add multiple conditions to calculated column but my formula is not working. The action is pretty simple that is why I feel like silly that it has ...
0
votes
2answers
27 views

Attempting to get a Calculated Column to output Yes/No (Formula)

I am trying to make a calculated column produce a Yes/No when: IF([Reminder Date]= [Today], “Yes”) and IF([Reminder Date] does not equal [Today], “No”) What is the correct formula?
2
votes
2answers
54 views

SharePoint Calculated Column depending on future date

I'm trying to create a calculated column which will return a specific name based on the date in another column. If the 'week ending' column date is within 28 days, I need the calculated column to ...
1
vote
1answer
28 views

How to sort after “group by” in a SharePoint Online list

I have created a list and populated it with some data. I have grouped it with ID column. So now it is appearing with count as below : Numbers in () are the count of times with same ID. I want it to ...
0
votes
1answer
31 views

Average function in Sharepoint - Not compute empty cell

I need the Average of the 4 variables, if one of the variable is empty, then the Average should be the Average of the 3 variables only. This is my formula. =AVERAGE(VALUE([Variable1]),VALUE([...
1
vote
0answers
29 views

Sharepooint Color Progress Bar Calculated column not working in Sharepoint 2013

I copied a formula for color coded progress bar from Path to sharepoint site And everything seems simple, however I think this code was written for sharepoint 2013 and I am getting error for ...
1
vote
0answers
27 views

Need to count entries

I am looking to make it so that each item in a list has a column that shows how many total items there are in that list that share the same value in a column as that list item. If that makes sense. To ...
0
votes
1answer
28 views

Complex calculated column in SharePoint

we have to create a calculated column from a string that can be of the form A01 (letter + 2 digit number) or it can be 2 letters plus number, as in AA1 the logis to use the ASCII codes of the letters ...
1
vote
1answer
7 views

Sharepoint 2007 - Date diference

i need to determine the number of days between two calendar dates. I have create a 2 columns, the first Date 1 and the second Date 2. The date is chosen by clicking on the calendar. What i require ...
1
vote
1answer
28 views

Using a Lookup Column (follow up question)

Following up this question on using Lookup columns: How to use LookUp column? How would you make this work looking up values from a calculated field (Store No) rather than manually inputting the ...
2
votes
1answer
29 views

Workdays/weekends/public holidays: is a sharepoint list the way to go for me?

Our team runs many short, streamlined projects. We currently have: A master excel sheet containing current phase/key data of each project Personal .xls tracking tools which automatically calculate a ...
0
votes
1answer
67 views

Calculating the total of numbers input in a field

UPDATE Hi again, Unfortunately it doesn't work. Here's what I've done: 1 - I've created 1 column called "Nr of hours" as Number column with no other settings. This column is included in my Edit ...
0
votes
1answer
74 views

Adding a Dynamic calculated field in SharePoint Edit Form View

I am looking to add a dynamic field in my Edit Form since calculated fields do not show on the Edit View mode. Using the Hillbilly format, I created a table... HTML <tr> &...
0
votes
1answer
23 views

Trying to determine if I can create a calculated column to do math based on specific text

I have been looking over many formulas and ways to do calculated columns in SharePoint. I had some success in Excel but just can't seem to get it to work OTOB in SharePoint. My goal is to Calculate a ...
0
votes
2answers
54 views

How do I use the TEXT function to delete the comma from my Calculated formula for the Fiscal Year?

I'm working in SharePoint 2013. I created a calculated column of data type = SLOT with the formula: =IF(Month(Created)>9,Year(Created)+1,Year(Created)) It works but it's returning the as 2,019 ...
1
vote
1answer
44 views

How do I create a calculated column to determine whether another column contains a link?

I am evaluating column content visually to determine whether it contains a link. I'd like to automate that with a formula in a column that tells me whether any link exists. That's the first step - ...
1
vote
0answers
53 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
1answer
29 views

Calculated Date formula not updating?

We have a Custom List in SP Online which pertains to parts needing to be inspected. Our list has the following fields: LAST-INSP: a manually entered date showing when the part was last inspected. ...
1
vote
2answers
49 views

IF Statement for SharePoint calculated columns comparing months

I'm Trying to display dates in a calculated column in the format of "DD - DD Month Year" (05-10 August 2018) or as "DD Month - DD Month Year" (30 August - 03 September 2018) if the Months are ...
0
votes
1answer
96 views

Calculated field gives “formula refers to a column that does not exist” error for auto increment

I'm working on SharePoint Online (new excperiance) and I've created a document library at the Site Content Types. For that type I'll have a column with auto increments and starting with TN. For this I ...
2
votes
1answer
34 views

Compare two fields in SharePoing using Calculated Column

I have two columns [Lease] and [MOT] whereby I like to have a column displaying message "NOK" or "OK" to make the user act upon it. I now created two calculated columns [LeaseReminder] and [...
1
vote
1answer
43 views

Need Assistance Updating an IF/THEN Statement

I have this calculated column formula for stoplights on my SharePoint list and I need just a little help updating/tweaking this particular formula. IF/THEN statements are not my forte. =IF(OR([...
1
vote
1answer
39 views

How to get a count of values in field using calculated columns

I have a calculated column and would like to get a count of all the occurrences of "true". So the first row shudl return 3 and the next 2 etc.. Can this be achieved using calculated columns Thanks in ...
5
votes
1answer
43 views

Easy way to write a correct formula!

Is there any easy way to write and validate a SharePoint calculated field formula? I am trying to find a formula builder like CAML builder!
1
vote
1answer
27 views

Calculated Column returning Undesired Result in one of over 300 list items

I have a calculated column in a Sharepoint List that is simply adding up 5 other columns with the following formula: =RWDPeriod1+RWDPeriod2+RWDPeriod3+RWDPeriod4+RWDPeriod5 The problem is that ...
2
votes
2answers
36 views

Calculated column displaying “#Name?”

I'm trying to display KPIs that show how long a list item spend in each status. Column name = Time In 5. =IF(OR(ISBLANK([Date entered 6. ]),ISBLANK([Date Entered 5. ])),"No KPI dates",DATEDIF([Date ...
1
vote
2answers
27 views

Formula of Calculated Column

I want to make a formula to my calculated column : If the DD Rating is High => Add 3 months to the [DD Sign-off Date] If the DD Rating is Medium=> Add 6 months to the [DD Sign-off Date] If the DD ...
3
votes
1answer
53 views

how to get minimum dates in a sharepoint list

How can i get a minimum date of some columns with dates field.I know i can use the min function(formula) with numbers but not with dates. is this possible using calculated columns if not would i be ...
0
votes
1answer
27 views

Calculated Field to show difference of hours as value

Hello I have three fields hours1, hours2 and total hours. Total hours is calculated fields based on the sum of hours1 and hours2. I use the formula =VALUE(TEXT(total hours,"hh"). It works if sum of ...
0
votes
1answer
86 views

SharePoint online, MS-Flow and calculated date time column #name issue?

I've got a current staff list with a StartDate (datetime) column and two calculated columns: 'DaysWorkedAt', 'YearsWorkedAt' I have an MS Flow workflow attached to the new employee list on new item ...