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
811 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
0
votes
3answers
1k views

How to set Date column with default value as calculated value?

One date time column: Target date Requirement: Need to set default 'Target date',5 Days ahead of item creation date. I have tried this:= but it is not working =[Target date] = [Created] + 5 Kindly ...
0
votes
1answer
921 views

Create Leave Management site using SharePoint List

can anyone suggest me how to create a time sheet in share point online. My requirement is when we select a start date and end end date the total leave days has to been shown by subtracting start date ...
1
vote
2answers
794 views

Calculating the week within Fiscal year in calculated field

I have been asked to make a list that contains a calculated column containing the week number within a fiscal year starting on 6th April 2015 (Monday) So for example, 6th-12th April would be week 1, ...
0
votes
1answer
15 views

Modern UI - Totals of german currency not showing

I want to show the totals of € in my modern SP-lists. But I do not know how to do it. Can someone help?
1
vote
2answers
30 views

Display The time an items has been in a status

Looking to how to display the time an item has been in a status since it was last modified. =CONCATENATE(IF(INT((Modified-Created)*24)>1,INT((Modified-Created)*24)&" hours ",IF(INT((Modified-...
0
votes
1answer
14 views

Reporting Date between Two Dates in Calculated field

We have a field called, "Reporting Date" and I am having trouble creating a calculated field to return whether it is Year7 or Year8. Situation: If 'Reporting Date' is between 2/9/2018 and 2/8/2019 ...
0
votes
1answer
17 views

Calculated Column in Custom List - IF Yes then Show

Example Columns: -Are You Bringing a Guest? Yes/No -How many Guests are you Bringing? Choice I'm trying to make it so when/if a user selects "Yes" on the [Are you Bringing a Guest?] column, it ...
1
vote
1answer
18 views

HTML Rendering in Calculated Columns - SharePoint 2019 on premise

I know that for 2013 and 2016 on premise that there is the capability to adjust a web app setting to allow HTML rending in calculated columnsm via PowerShell: CustomMarkupInCalculatedFieldDisabled ...
0
votes
2answers
446 views

Adding Html to a calculated columns

My scenario : I have a calculated column which need to show a specific image based on another choice column(Status:closed,open or active). I have set the calculated column type as Number. I tried to ...
1
vote
1answer
919 views

Sharepoint Percentage Working Out

Scenario: We quality score work in our business to ensure this is updated correctly and we give each 'engineer' a mark out of 5 each week. Currently we are able to work out the percentage each week ...
0
votes
0answers
9 views

EXCEL import: share point calculated field source columns are blank while others can see data in them

I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no ...
0
votes
1answer
31 views

Need help with a work around

I need to take the 'Office' display of the 'Created By' column and display the first 5 digits of it so that my flows can run a conditional check on it. The reason is that Microsoft flows has all the '...
0
votes
1answer
16 views

Share Point how calculate days in whole number

I'm using this formula in shapoint to calculate the difference between start date and due date. This formula is working very well, but when the approvals receive the automatic email about the Out of ...
1
vote
1answer
970 views

Calculated column to take folder name in the library

Can I configure a calculated column in my document library to take the name of the folder where a document is uploaded to? if yes how? for e.g If there is a folder called 'HR' I want the value 'HR' to ...
2
votes
1answer
630 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
0
votes
1answer
945 views

Padding a numeric string in a calculated column

I need to pad a numeric string using a SharePoint calculated column. I have two fields, Sectiontxt and calcPadNum. For example, if a user enters 1.12.1 into Sectiontxt, I want calcPadNum to be 011201. ...
1
vote
1answer
1k views

Calculated Fields and Outputting to Excel

So my issue is with SharePoint 2007 and what is happening is that when I output to a excel spread sheet a custom view, If I export some calculated columns it also brings in the columns that were used ...
0
votes
1answer
12 views

SharePoint 2013 Formula Syntax: Choice Column Generates Number in Another Column

I am trying to make the following happen on a list: If a user selects "Most" as a choice, then another column will return as 1. If a user selects "Somewhat" then that column will return a .5. If a ...
39
votes
7answers
91k views

How to use Today and Me in Calculated column

I want to use a combination of Today and Me in SharePoint 2013. I am trying it in Office 365 it gives me the below error Calculated columns cannot contain volatile functions like Today and Me. Can ...
1
vote
1answer
1k views

Sum of a column by month using a Calculated Column

Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The ...
0
votes
1answer
1k views

Help with Conditional Statement (Calculated Column)

I have created a sharepoint workbook with contract information. Three columns in this sharepoint have dates. ([Planned Release Date] , [Revised Release Date] , and [Current Release Date]). I have ...
1
vote
2answers
1k views

SharePoint Online - Link to Item - Calculated Column

is it possible to assign Link to Item to a Calculated Column in SharePoint Online? I have read a few solutions suggesting editing AllItems.aspx in SPD designer but the calculated column is not listed ...
0
votes
2answers
23 views

Calculated Column Formula - Nested IF Statements

Im new to formulas, My issue is i want to display the current location of said item and keep the old locations so for now i have three columns Location1 Location2 and Location3 and i want to have a ...
0
votes
1answer
2k views

sharepoint calculated column to round a number

I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be ...
0
votes
1answer
1k views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
0
votes
1answer
21 views

Calculated Date column to determine if 30 days has passed

I have a column "Document Date" which is manually entered. I would like to create a calculated column that defaults to "Yes", unless it's 30 days after the document date in which case it automatically ...
0
votes
2answers
2k views

Running Retention Policy from Custom Calculated Column

I have a calendar list in which to post deadlines. I need a reminder to be sent out two weeks before the deadline, so I am trying to put in a retention policy. To measure the date to activate this ...
1
vote
2answers
2k views

SharePoint 2007: Calculated column - formula for calculation based on column containing NA

In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value. There is a separate calculated column which ...
0
votes
0answers
15 views

Calculate Business Days

I've been using a calculated column with some IF statements to calculate the number of business days between 2 dates. =IF(ISERROR(DATEDIF(Created,Today(),"d")),"",(DATEDIF(Created,Today(),"d"))+1-INT(...
2
votes
1answer
68 views

3rd Tuesday Calculated Column not working when there are 5 weeks in the month

Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month. I have one column called Current Patching Date (date/time field) - stores a date I ...
0
votes
1answer
745 views

Calculating overdue status in a Sharepoint list using calculated column

Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to ...
2
votes
4answers
8k views

Unable to add a Choice field to a Calculated field (SharePoint Foundation 2013)

I'm not sure why I'm having this issue, as all material says that I should be able to do this... I have a required choice field that I would like to use in a calculated column. However, when I try to ...
2
votes
1answer
4k views

Calculated field based on values in other columns

I have a new SP 2013 List that I would like to add a new field with a calculated 'score' based on the values of a few other columns. For example, The Choices for Col1, Col2, Col3 and Col4 are all ...
0
votes
1answer
3k views

How to auto populate new column based on another column

hope everyone is well; I am trying to auto-populate a column based on another column's choice. For Example, Column A (labeled Job Title) there are 4 choices. I would like to have another column (...
1
vote
1answer
722 views

How do I sum a column in SharePoint 2013?

I have a requirement that I need to sum a column in my SharePoint page then send a email if its one or bigger. I have got the email part down and its working, the problem is everything that I can ...
1
vote
2answers
3k views

Can sharepoint calculate the number of “business hours” for a list item to be completed?

I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case. Business Hours Monday to Friday 5am - 8pm ...
1
vote
1answer
625 views

Calculated Column to extract text within file path

Due to SP limitations in workflows for extracting text strings, I'm looking for another way to skin the cat. If I have a single-line text column that has a file path like: C:\folder1\folder2\...
1
vote
1answer
28 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
19 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
46 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
24 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?
5
votes
4answers
7k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists.
0
votes
0answers
12 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
20 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.
2
votes
3answers
1k views

Calculated field shows text instead of image

SP Online, task list. Created calculated field with this formula: =IF([Task Status]="Completed","<DIV><img src='https://cdn.sstatic.net/Sites/stackoverflow/company/img/logos/so/so-icon.png /&...
41
votes
16answers
22k views

June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back

On June 13th 2017 all SharePoint calculated columns with HTML markup stopped working. Basically the fields now render text (regardless of setting the data type to number). The gist of the notice ...
0
votes
1answer
644 views

Highlight upcoming/overdue calculated column dates in a training list

I have a list to track customer training. Two of the trainig items are recurring; Ethics - annual and GPC Refresher - biannual (every two years). The due dates for each training requirement were ...
0
votes
2answers
38 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
17 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 ...