Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulas. They allow you to 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
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
3answers
861 views

How to count number of days from SharePoint list?

How to count number of days between two dates from SharePoint list using CAML query/JavaScript? Thanks
0
votes
1answer
2k 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 ...
1
vote
1answer
884 views

Calculated Column based on [Start Time] showing series start date instead of event start date on recurring event

On my Calendar list I have recurring events. I have a view that wants to filter on the [Start Time] of the event but that field isn't available in the filter options of a view. After some research I ...
0
votes
0answers
17 views

Creating calculated columns using data from calculated columns

I tried to create a calculated column which uses data from other calculated columns in the same list. I'm getting an error message, that the columns do not exist even though i can select them from the ...
0
votes
0answers
6 views

I enter large formula into calculated column and click ok, no errors appear, and when i click edit the column the majority of the formula is gone

I enter a fairly large formula consisting of nested IFs, ANDs, & OR statements and the formula is accepted without errors when I click ok. When I then hit edit to view the formula again, most of ...
1
vote
1answer
28 views

Calculate the week from a date, Jan 1st = week 1

I'm looking for a calculated column formula which will calculate 1st January 2022 as week 1. I'm in Europe, so, like most of the world, my date field 01/01/2022 = 1st January 2022. I would like 1st ...
0
votes
1answer
18 views

Remove Trailing Zeros from Sharepoint List Lookup Field that is based on a Calculated Field

I have two Sharepoint Lists, one of which has a Primary ID field that is a Calculated Field that simply equals the Sharepoint generated ID field. Table 2 has a Lookup field that pulls in this new ...
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
1answer
1k views

SharePoint Purchase Order Tracking

I need to create a Purchase Order tracker. There are a few parameters that I'm unsure how to account for in building the solution. Our system allows multiple items to be ordered under a single PO ...
0
votes
1answer
20 views

Can I make a calculated column that uses text in the boolean comparison but returns a number?

I'm trying to make a calculated column with a 5 level conditional as follows: =SI([Impacto Inherente]="Crítico";400;(SI([Impacto Inherente]="Mayor";300;(SI([Impacto Inherente]=&...
4
votes
5answers
43k views

How to get Full Name in 'Calculated Column' from User Id in SharePoint List

I have a list with a column which consist of user id. there is also a calculated column which has to get the full name from this id. I was able to achieve this by installing custom WSP. Is there any ...
0
votes
1answer
19 views

Calculated column, formula to count how much time left before deadline

I have 2013 list (on premises) and I have a column "Deadline date". I need to create a calculated formula which 30, 60 and 90 days before will show such text, 30, 60 or 90 days left before ...
0
votes
2answers
32 views

Date and Time Calculation in Sharepoint Excluding Weekends and displayed in minutes

The code below is working well to calculate the time between two dates and excluding weekends. However, I would like to modify it to just return the number of minutes in number format so I can do some ...
0
votes
1answer
17 views

I want to look at 2 date & time fields and compare that to now to return a status

We have locations that are open or closed for the day. I want to create a list that has a status column that says if that location is open or closed based on two other date and time fields. Example 1: ...
0
votes
1answer
1k views

DATEDIF function to also work with negative numbers?

I am trying to write a very simple equation as Calculated Column on SharePoint List. This equation works easily in Excel, but I'm having trouble with it on SharePoint List. I am trying to find the ...
1
vote
2answers
884 views

Calculated column from a multiple lines column

I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column. =IF(ISERROR(FIND("flight",[shipping])),"ground","...
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 ...
0
votes
1answer
13k 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
873 views

Calculate Columns to create Leaderboard

I have created an InfoPath form for a company-wide Step Competition that will have different communities competing against each other for walking the most amount of cumulative steps. Each form ...
0
votes
1answer
22 views

Date and Time Calculation excluding weekends

I want to figure out the amount of time between Quote Start Date and Quote Complete Time in minutes and exclude weekends. I have tried several examples I found online but I always get a syntax error. ...
1
vote
1answer
57 views

Conditional Calculated Date Column

I currently have a calculated column [Retention Date] that is only based on one value, the completion date. This is for certain certificates so I can use them for styling in my DataTable. The issue ...
1
vote
1answer
29 views

How to remove space from a title column in SharePoint online

I am sure this question has been asked many times, but would someone please be able to guide me with my issue with removing a space between title word, e.g. title "Project ABC" and I would ...
1
vote
1answer
2k views

Calculate 14 days or less on Expiry Date column from Todays date

I have a library with a column 'Expiry Date'. I wish to create an additional column to advise the user if a particular entry needs to be reviewed. The parameters for this is if the 'Expiry Date' is ...
1
vote
1answer
926 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
3answers
2k views

Column days pending - how to update automatically

I have made a few differents options for days pending with SharePoint. I would like to know, how many days a item is open. First i tried this solution: https://www.solwebsolutions.com/blog/entry/...
0
votes
0answers
14 views

add-SPOSiteCollectionAppCatalog breaks calculated fields

Has anyone else noticed some weird behaviour with sharepoint 365 when after you run. add-SPOSiteCollectionAppCatalog The caculated fields breaks. i.e when you click 'add field' and then choose ...
0
votes
1answer
52 views

SharePoint List - Advanced Formula - 3 Criteria

I need to use a SharePoint list instead of an excel and I can't find a way to write the following formula. In the excel I use VBA. The case is: Each user will import the following data: Column A: ...
0
votes
1answer
11 views

SharePoint Online calculated column formula error

I would like to create a simple calculated field, that returns a text if a value is greater than another. Column [Bruttó összeg] is number type. I just copied the formula from the official Microsoft ...
1
vote
1answer
874 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 ...
0
votes
1answer
1k views

Sharepoint 2010 Calculated Column: How to get value before item gets modified?

I have a list that has a Status-field. If the status changes, a modified date in another column should indicate, when the status has been changed. My idea was to create a duplicate of this Status-...
0
votes
3answers
4k views

Referencing Choice Field in Calculated Columns

I have a question regarding Calculated Columns. I have a Column Called "NextMileStone", this column can contain "PM010", "PM020, "PM040", "PM070", or some other choices that would be the "else" ...
0
votes
0answers
12 views

Calculate Business Days which are Monday - Thursday in this case

This works perfect for standard workdays but wonders where I can update for just M-Thur only IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([...
0
votes
2answers
39 views

Using calculated value columns using date

I have a SharePoint list that has the following columns: I'm having a hard time making this. I want to make the Status column a calculated value dependent on departure and return. I want to show if ...
0
votes
1answer
15 views

More than 19 IF Statements in a Formula in a calculated column

I have the following formula in a calculated column which contains 19 IF statements. I cannot add any more but I need 6 more. Any ideas to solve this. =IF(AND(Likelihood="Rare",Consequence=&...
0
votes
2answers
45 views

Averaging Values of Documents Column and Displaying in Document Set Item

I tried creating a calculated column but it just applies it to each individual item instead of averaging the values from each item together. So for example, I have a document set and within that ...
0
votes
1answer
16 views

Converting Excel formula to SharePoint Calculated column formula

I'm pretty new to SharePoint calculated formulas and am struggling to convert an Excel formula I have to a SharePoint calculated column formula. The Excel formula is =FLOOR(280-(J5-TODAY()),7)/7&&...
1
vote
2answers
34 views

SharePoint List calculated field syntax

I am unable to get this SIMPLE calculated field to work. Note that I am not a programmer and do not use codes a lot. So please help in details. I have a SharePoint list where I want to get a simple ...
1
vote
1answer
20 views

Calculated Column to show only Month and Year from formula results?

As is, the formula below works perfect for my project. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there ...
1
vote
1answer
2k views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
0
votes
1answer
891 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
1answer
19 views

Returning a value based on date of return

Please I need help. I have a column called "Date_Of_Return". I want to create a calculated field to return "SMP" if the arrival date is greater than "01-11-2021" and ...
0
votes
1answer
2k views

how do I add 90 days to a calculated column?

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following: If column A is blank, and column B is greater than 90 days from ...
1
vote
1answer
1k views

Read calculated column previous value if status equal Closed

I have a "Days Past Due" calculated Column and used your calculated formula (link Sharepoint 2013 Custom List Calculate difference between Today and Column Value) and is working fine. But there is ...
1
vote
1answer
1k 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
1answer
924 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
1answer
1k views

SharePoint Online: Calculated field with week number starting Saturday

I've found a few ways online to calculate the week number but none that allow me to start the week on Saturday. Here is the formula that I tested, but doesn't give me Saturday-Friday. =INT(([Time In]-...
2
votes
2answers
44 views

How to get the change date for a specific column based on its value

I'm new to SharePoint and I'm not sure if the tool can help me with this issue: I have a list with several items to organize activities/projects, as illustrated in the figure. The "Status" ...
2
votes
2answers
918 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 ...
0
votes
0answers
14 views

How to display revision number from SharePoint column to a word document

I have tried this method on the below link but it did not work https://social.technet.microsoft.com/Forums/en-US/d7edacd9-3818-4b66-982a-daa1846fbe2a/add-the-sharepoint-version-number-to-a-word-...

1
2 3 4 5
23