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
0 votes
0 answers
9 views

calculate difference between two dates in sharepoint, show days, month, years

How to convert this formula from excel to use in SharePoint: to show age in day, month and year? Current formula: =IF(DATEDIF(TODAY(),[birth],"y")=0,"",DATEDIF(TODAY(),[birth],&...
1 vote
4 answers
7k 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
0 answers
12 views

Add a day "0" to the Date Picker (ie 0/6/22)

I have read several other posts on this topic but haven't quite been able to get what I want to happen without going through a complicated workaround. Here's the problem: I need to display the date ...
1 vote
1 answer
2k 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 ...
1 vote
1 answer
22 views

Using nested IF and IF(AND) statements to display different info in calculated columns

I'm trying to display some text in a calculated column depending on whether or not the input of the other columns is blank. The columns are single-line text: [Creator] and [Organisation]. The idea is ...
2 votes
1 answer
1k 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 ...
1 vote
1 answer
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 ...
2 votes
2 answers
10 views

Chronological grouping of dates formatted as MMM YYYY in Sharepoint

I formatted my list to group by dates in a format of MMM YYYY in an ascending order. The formula I used was: =TEXT([Start date],"mmm yyyy") However, now SharePoint groups the dates using ...
0 votes
1 answer
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
1 answer
12 views

Calculated column to show negative number as zero

I have the below formula in a calculated column, which in some instances will return the number as a negative number (eg. -1234) how do get the formula to show the negative number as 0. =IF(ISBLANK([...
0 votes
1 answer
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 ...
0 votes
1 answer
17 views

Need to create an hyperlink in a calculated field

We are using SharePoint 2019 On premises. I have a column called "Email" that give the email address of the connected user, but in plain text. I would like in another column to make this ...
0 votes
0 answers
11 views

SharePoint 2016 Calendar/Image in Month View Title

I am trying to show picture (based on condition) in Month View. I've managed to manipulate HTML Markup Functionality and now I am able to show picture in Calculated column but in "All Events&...
0 votes
3 answers
1k 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
1 answer
22 views

Calculated column issue in Sharepoint List - Excel Formula Given

I have tried to apply the following formula in the SharePoint list but somehow it gives an error. Can the same formula be used or any changes are to be made? Please help me out. I have given the ...
1 vote
1 answer
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
1 answer
941 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
0 answers
14 views

Calculate difference between dates and roundup

In SharePoint, I am trying to calculate days between two dates. My calculated formula is: =DateClosed-Created This works, but how can I change this to have the following result: If the outcome in ...
1 vote
1 answer
26 views

Calculated Column IF OR AND Formula not Working

I'm trying to create a calculated field with the following formula, but when I try to save the column with this formula it returns a syntax error. What's wrong with the formula? Formula: = IF( OR( ...
1 vote
2 answers
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
1 answer
23 views

How can I include the the original Item ID# in a new Item created/cloned using Power Automate flow?

I am using Power Automate to clone original Items in an existing SharePoint List. All is working perfectly, as the clone flow results in an exact copy of the original List Item. Now my users want to ...
0 votes
1 answer
2k 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 ...
1 vote
0 answers
13 views

Calculated column dates are a day out when queried in Flow?

I've got a SharePoint list that is used to work out renewal dates of software. The three key columns are "NCE SKU", "NCE Purchase Date" and "NCE Renewal Date". The &...
0 votes
1 answer
13 views

Trying to use WEEKDAY function to make a column always return a Friday date, based off another date column

So far I have this, anyone know why it isn't working?? Goal is to return the first Friday after the [Est. Stock Date]. =IF(WEEKDAY("[Est. Stock Date]"=1,[Est. Stock Date]+5,IF(WEEKDAY("[...
1 vote
2 answers
1k 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","...
0 votes
1 answer
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 ...
0 votes
1 answer
10 views

Calculated Column formula to find two values in column

I have a Single Line Text Column(Content). I would like to create a calculated column that returns "Yes" if the Content column contains either of the two words- "Urgent" or"...
5 votes
4 answers
5k views

What is the workaround for limit in nested if statements in sharepoint calculated column?

I have to create a list wherein when user inputs a data to a column the corresponding calculated column should take the data and analyze the condition and then return the value, but my SharePoint ...
1 vote
0 answers
43 views

My Column Formatting No Longer Works (and the problem seems to only be on my computer...)

I have a column that is a Risk Index that calculates based on other columns. The equation calculates as following: -50 0 30 70 100 -50 = Pending Review / 0 = Completed, no risk / 30 = Risk Mitigated ...
0 votes
1 answer
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 (...
1 vote
2 answers
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
1 answer
927 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
1 answer
22 views

If statement comparing a calculated result to a number returns false even if they're the same

Number field "QuantiteStockageConteneur" = 7922.55 Currency field "TauxStockageConteneur" = 0.28 Currency field "StockageDeConteneur_ParPiedCube" = 2218.31 I have tried: ...
1 vote
1 answer
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 ...
0 votes
1 answer
30 views

Calculated Column using current year (Today)

I need to create a calculated column that would need to show the years since a document was published. Notice that I'm not saying [Created]. The issue is that I have a document library where our ...
1 vote
1 answer
962 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
3 answers
3k 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
0 answers
9 views

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well. Below is the code I'm using: =IF(OR(HRW01+HRW02+HRW03+HRW04=4,...
1 vote
1 answer
900 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
3 answers
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
1 answer
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
0 answers
11 views

SharePoint 2016 - Created Start/End filter columns, but recurring events aren’t working. calculated fields only stamp the first & last event day/times

So I have set up four Calendar Views and four corresponding Overlays to display three colors based on filters: Scheduled Tasks: Category of “Scheduled Task” w/ Blue Overlay color Current Tasks: ...
0 votes
1 answer
80 views

How to Automate Percentage Complete on Sharepoint List when answers are text

I have a sharepoint list I am trying to figure out how to utilize power automate and flows to calculate a percentage score column that runs an initial calculation and then updates as new selections ...
1 vote
1 answer
29 views

How can I use the doc ID in a calculated field

The document ID is this: EY3P5SDA5APP-512271551-6 and I would like to isolate the last digit (here 6) using a formula. I tried this formula: =RIGHT([Valeur d’ID de document],LEN([Valeur d’ID de ...
0 votes
1 answer
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]-...
1 vote
1 answer
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
1 answer
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
1 answer
1k 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(...
0 votes
1 answer
1k 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
1 answer
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
2 3 4 5
24