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
1
vote
2answers
27 views

=IF(DATE(YEAR([Compliance Date]),MONTH([Compliance Date])+11,DAY([Compliance Date])), “Due”, “Not Due”)

I am trying to create an If statement that looks at a date column in sharepoint and if its 11months after that date the column displays yes. any help on this as: =IF(DATE(YEAR([Compliance Date]),...
0
votes
1answer
22 views

Create a calculated column to be yes IF([due date]=[Today]-31, “yes”, no) or custom view

Im trying to set up a calculated column to look at another calculated date column and if its under a month (ie its due to be renewed) than say yes. if i cant do that can i create a custom view from a ...
0
votes
0answers
12 views

SharePoint Calculated field Failed to update value on all items on Large List

So this is the problem: I have a list with around 1 million records I added a Calculated Column, with a very simple formula: "0" + [textfield] and return it as number The request returned an ...
0
votes
1answer
35 views

Update a column if Date in another column has been breached?

I am trying to update a column value IF the Date presented in another column has been breached. I will then need to format the row the has breached this date in Red. The columns are: Date ...
0
votes
2answers
12 views

Can't get conditional syntax correct

Have [Tier] column with choice values of 0,1,2,3. If [Tier] = 0 calculated column should = 0 If [Tier] = 1 calculated column should = 4 If [Tier] = 2 calculated column should = 24 If [Tier] = 3 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
30 views

Adding a calculated column to a Large List — how much time it will take?

I have this question because we have a Production deployment and we need to update some lists with about 1 million items stored on them The calculated field formula is very simple :take 1 field and ...
1
vote
1answer
951 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 ...
1
vote
1answer
1k 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 ...
0
votes
0answers
15 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
42 views

Calculating “Task Aging” without weekends

I am calculating the number of days a task is aging. This works great: =DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy")) However, I need the counting to STOP when the ...
3
votes
3answers
3k views

Difference between two dates in hours

In SP list there are two date/time columns, column A and B. I want to calculate difference in hours between those two dates, but only on working hours. My working hours are between 8AM (08:00) and 4PM ...
2
votes
1answer
718 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
30 views

Calculate max(num) +1 with calculated value? (Help please)

I want to do this: MANUEL 1 PEPE 1 MANUEL 2 LUIS 1 I want to get the number by a calculated value, but if the name is duplicated get the max(num)+1. Example: if (NEW.INPUT) exist find max(...
0
votes
0answers
22 views

Sharepoint 2013 Button in List View to Start an SP 2010 Workflow

I was wondering if someone could help me to get this feature in SharePoint list view. I want to get a button in Custom List View itself with a Calculated Column to start an 2010 SP Workflow. I ...
0
votes
2answers
22 views

String Calculation SharePoint 2010

I have the below string stored in a SharePoint Column: 11608,613,12,12643,12644,12656 I want to extract the value after the last comma. That is I need to extract only 12656 and use it for other ...
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
19 views

Value of the Yes/No Column

What is the values of the Yes/No Column in SharePoint? 1, 0 Yes, No "Yes", "No" True, False Trying to use calculations: =IF([Col1]=Yes, 1, 0) So if it's true, put 1, else 2. But not matter what, ...
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 ...
1
vote
2answers
2k 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 ...
1
vote
3answers
23 views

SharePoint 2013 calculated column -compare dates

I thought this is easy but somehow I didn't get this right. I entered the following formula in the calculated column but the outcome is incorrect. For example, when [Target_Finish]=10/10/2019, the ...
0
votes
2answers
16 views

Calculated Column with IF ISBLANK, else if “ABC”, then return “XYX”

If [OH:Subsample ID] is blank, OR if it contains "ABC", then the calculated field should return result "XYZ". No idea how to put that into syntax. I can get two separate lines, but can't get them ...
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 ...
0
votes
1answer
27 views

Calculated Column Not Displaying Anything

I have this really odd issue that works in 1 document library (first image) and doesn't for another (second image). I have 2 columns, column 1 called Published Date (Flow) that is of type string (...
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
32 views

Calculated Date Column - Multiple IF and more

I've been trying to work this out for 2 days and I'm probably overcomplicating this but here's what I'd like to do. If the employee has been employed >= 2 years they only need to take certain classes ...
0
votes
2answers
34 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
22 views

How can I populate a Library or List column name with the name of a file that has been uploaded?

Using SharePoint Online, how can I populate a column with the name of a file that has been uploaded? Seems all the related Q&A I am finding have more complex twists, this I hope is straight ...
16
votes
2answers
92k views

Using calculated field to retrieve substring of another field

Suppose I have a field that contain the following data: ========================== | Email Address | ========================== | Jack@wonderland.com | | Peter@nobodyland.com | | Jill@...
1
vote
1answer
20 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
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 ...
1
vote
1answer
17 views

Extract different text values from the title using calculated column

I am looking to find a way to extract text from the TITLE of an item when that text value could be different. Example: TITLE = N10 2019-2020 Kilo Project R Sec All Data Calculated column called ...
0
votes
1answer
33 views

Exclude weekends

I am working on a vacation calendar project. I have a custom lists with 2 columns, one being StartDate and the other NumberOfDaysTaken. I am using a simple SharePoint formula (=FromDate + [How many ...
0
votes
0answers
10 views

SharePoint 2013 Convert time pulled by JavaScript to different time zone

I have a text column in a list that receives the value of a JavaScript timer that's attached to a SharePoint survey that populates the column in this format: 2019-08-28T16:56:19.531Z Can I create an ...
0
votes
1answer
1k 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 ...
0
votes
1answer
31 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
28 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
22 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
4k 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 (...
0
votes
1answer
17 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
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
753 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
1answer
674 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\...
0
votes
1answer
792 views

I want the Left 10 characters of the name column calculated in another column

A lot our names on SP are real long names; I would like to get say the left 10 (or any number of characters I put in the formula) characters of the name to calculate into a column. This would make ...
1
vote
0answers
30 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. ...
5
votes
4answers
8k 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.
1
vote
1answer
41 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 ...
2
votes
2answers
18k views

Calculated date column to take into account working days

In my SharePoint list I have a default due date of =Today+10 How can I get this default date to be 10 working days from today? I'm not too worried about taking into account public holidays etc, ...
0
votes
1answer
660 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 ...
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 ...