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
2answers
25 views

Calculated column formula for an expiry date based on drop down selection

I have a dropdown list named “Expiry Period” with options as follow:- Yearly Monthly 2 weeks 1 week Other options might be added later on Now I want to create a calculated column named “Expiry Date”...
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?
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 ...
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
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
0answers
10 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
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 ...
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 ...
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
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
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
0answers
16 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(...
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?
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
21 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
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 ...
0
votes
2answers
39 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
36 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
37 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
32 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
65 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
39 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
36 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
61 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
50 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
52 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
41 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
55 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
62 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
32 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
51 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
51 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
28 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
32 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
8 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
38 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
122 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
89 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
47 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
59 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 ...