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.

Filter by
Sorted by
Tagged with
0
votes
1answer
29 views

Calculation in Calculated Column varying based on null values?

Here's one I've never dealt with before: I have calculated columns (in a SharePoint 2013 survey) that calculate values based on particular survey questions. One of those values, however, is an "N/A" ...
0
votes
1answer
24 views

How to calculate the average of a field using a date range

I need to calculate the average of a number field called "Total" over a date range. I have a To and From date picker. I'm sure this can be done in Sharepoint, but I have no idea of the logic to use. ...
1
vote
1answer
18 views

Calculated Column Depending on Different Row Value

In our department, we can make offers with different packages. These offers are sometimes only one device and sometimes set. If the proposal (project number) package was submitted in a way, it should ...
0
votes
1answer
15 views

SharePoint 2013 - Calculated Columns - Created timestamp is 6 hours into the future

I am trying to calculate the difference between created date and now() in calculated column in SharePoint 2013 but i have issue with the time zones. The servers are in Europe (UTC +2) and some of the ...
1
vote
1answer
13 views

How do I insert “Created by” into a concatenate formula?

To have month view in a SharePoint calendar which displays the value of more than one field. I would like to combine the Title with the user's name using calculated column type. But Createdby can't ...
1
vote
0answers
27 views

Getting “#NAME” from SharePoint Survey calculated column

In the results for a Survey done in SharePoint 2013 (survey list - type that I'm "inheriting", if you know what I mean). I noticed we're getting "#NAME" in some of the areas we're pulling down. ...
1
vote
1answer
37 views

If Statement Giving Wrong Output Issue Calculated Column

I have this simple if statement where there are two columns. Column 1 = Score Column 2 = Test This is the If Statement Code: =IF([Score]>70,"A","F") If the score is greater than 70 it should ...
1
vote
2answers
30 views

Trying to create a Calculated Field - Getting an error. Double checked spelling etc

=Department Name&" - "&Title&" - "&Department Team&" - "&Department Branch I am trying to create a calculated column from the following existing columns: Department Name ...
0
votes
1answer
15 views

SharePoint 2016 Calculated Column Link Problem

Good day, I have a project and a very tight deadline. I have developed a tool for managing events. The system was developed in SharePoint 2010 which was migrated to 2016. I used a calculated column, ...
0
votes
1answer
13 views

SP2013 Delimited values to other columns

Here's an interesting one: I have a list where one text column accepts multiple delimited values. (By that, I mean multiple values separated by delimiters.) Is there a calculated feature where I ...
0
votes
1answer
28 views

List view grouped by type “Number” then by type “Text” does not expand to show entries in SharePoint Online

List view is grouped by field "Created year" of type "Number" and then by field "Created month" of type "Text" does not show entries while trying to expand the grouping. Both are calculated columns ...
1
vote
2answers
30 views

How to sort column fields and get its total

Dear SharePoint Experts, I would like to ask for tech support regarding on the screenshot that I attached. As you can see from the image, I have a My Requests, All Items, My Balance views, in My ...
1
vote
1answer
13 views

Calculated Column Depending on Different Column Value

I am new to SharePoint. I am looking for a way to assign a value for a column depending on another column's value. For example, the choice column dictates "New York" the value of the calculated ...
0
votes
1answer
24 views

SharePoint Calculated Column, extract only ONE numerical value

I've seen the other articles that answer very similar questions but those formulas do not work for me, I needed to post a new question. I have the following column values: Leadership;#4# Character;#...
1
vote
1answer
19 views

Sharepoint list - if a value is submitted twice or more - show the amount of entries in a different column

I'm working with MS Flow / Form and I'm trying to show the amount of time a single user submits something into Sharepoint. (see below) Is this possible through a formula?] Thanks.
0
votes
3answers
30 views

Using IF in Sharepoint

I am trying to reproduce an Excel formula in a SharePoint List. Below is the Excel Formula: =IF(H2="",DAYS(TODAY(),G2),DAYS(H2,G2)) Below is what I am having in SharePoint: =IF([Aproved]="",DAYS(...
0
votes
1answer
20 views

Calculated Column result equals null

I'm trying to create an "If" formula that will return lastname and firstname if the middlename column is blank. I also want the result to be lastname, firstname, and middlename if the middlename ...
0
votes
0answers
9 views

Calculated column % Complete based on value of other column?

I am new to SharePoint. I'm trying to figure out how to create tasks that display the percentage complete based on the value of other columns. I'm having trouble with the syntax. I have three columns ...
0
votes
1answer
28 views

Calculated column based on value of other column

I have two fields in a SharePoint list - 1. Archive Status (Choice field which are Active, Archived and Cancelled) and 2. Archived Date (Date Field). Is it possible to automatically calculate the ...
0
votes
1answer
14 views

Separating Multi-select column values into individual columns using calculated columns

I have a Multi-Select column labeled Email that allows users to select multiple email addresses populated from an external Sharepoint list. I then get their choices and update a single-text column ...
1
vote
2answers
14 views

Using if and isblank to calculate a result

I am trying to calculate a column based on two others. One might be blank and if it is I want the formula to use today's date. I have tried several ways and tested it in excel to ensure I am on the ...
1
vote
2answers
38 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
23 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
21 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
34 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
20 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
29 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
12 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
19 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
18 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
36 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
31 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
27 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
21 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
29 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
54 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
47 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
34 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
14 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
24 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
40 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
40 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
128 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
41 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
40 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
30 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 ...