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
1answer
431 views

Create Sharepoint View Filtered by Current Quarter in sharepoint lists/Library

I'd like to create dates for the projects we are working on in our company, and it has to be filtered by quarters and calculated columns. Can any one help me with that? Please and thank you!
0
votes
2answers
378 views

Problems on RIGHT function on Sharepoint

I have a calculated field which is filled in automatically thanks to a simple formula: =(X*X*Z/162-Y*Y*Z/162)*X This generate a number like: 1.637.037 I have a problem on adding RIGHT function to ...
0
votes
1answer
230 views

Replace "," to ";" in single line of text column

I need an advice on the following situation. I have column that is single line of text which stores email addresses separated by comma (the value is created by lookup table). Example: ABC@yahoo....
0
votes
1answer
185 views

SharePoint 2010 List Custom ID Column Creation

My team is trying to create a custom ID column for our SharePoint 2010 list. The column should show YYMMDD-ID, with YYMMDD the date the item was created and ID the ID of the item. I tried using =[...
0
votes
1answer
84 views

Simple ISERROR Calculated Field Assistance

I have a simple calculated field =[Total Reviews Failed]/[Total Reviews Completed]. The problem is that if these numerical columns are blank, The field returns #DIV/0!. Can I replace the #DIV/0! with ...
0
votes
2answers
27 views

Response date fucntion

I want to obtain the response date (number of days) based on other parameters. Used to use an excel file for document management, trying to upgrade to sharepoint and use meta-data. The formula i'm ...
0
votes
1answer
290 views

Average and Total in a Calculated Column

I am currently calculating the difference between created date and modified date in my SharePoint custom list. Is it possible to also calculate the average of the # of days, totalled by month? I ...
1
vote
2answers
257 views

Calculated Column Working Not Working

I have a calculated column that worked in SharePoint 2007, 2010, 2013, and 2016. But now in SharePoint 2019 the calculated column is not appearing right in the column instead of showing the employees ...
0
votes
3answers
718 views

Column to display day of week

I am using the following formula to calculate the day of week based off of the Start Date column: =TEXT(WEEKDAY([Start Date]),"dddd") The problem is that when I create the event on the calendar view ...
1
vote
1answer
52 views

Filter pane bug in modern experience when using a calcuated column

I've run into an odd bug when using the filter pane to filter a calculated column in SharePoint 2019 on premise. When using the see all option, the "8_" text is added to the filter value and the ...
0
votes
1answer
94 views

Number Reset as Beginning of the Month

I have an ticket tracking system in a SharePoint list that runs by a Fiscal year, month, then counts for the month. And my leadership wants to automate the number assignment. Ex: ABC (current ...
0
votes
1answer
972 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
1answer
72 views

SPO Calculate Total Cost Per Group View

I will try to summarize my main goal if it's possible to achieve it. I have a list which contains the following columns: Invoice ID Number, Item Name, Quantity, Item Cost,Total Cost. What i want to ...
1
vote
1answer
51 views

Columns doesnt count right

So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. ...
0
votes
1answer
34 views

Calculated Column with Multiple Queries

This may seem really basic but I'm struggling to get my head around it. I have 2 boolean columns (Checked by TL and Checked by CSS), I need a calculated column to give me one of three results; 1: ...
0
votes
1answer
19 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
3
votes
2answers
166 views

If exceed 24 hours show "23:59:59"

So I got this calculated column called "Due time" with this format in it: =IF([Hours]<24&&[Minutes]<60;CONCATENATE([Hours]&":";[Minutes]);"23:59:59") I only get syntax error with ...
0
votes
1answer
22 views

Averages of Column values placed into either its own column, or workflow variable

I've researched this one - and while I have found many helpful articles CLOSE to it, nothing hits exactly what I'm needing. I'm trying to populate either a variable in a workflow OR a column with the ...
0
votes
1answer
24 views

COUNT of items in list, with more requirements

Here's my current predicament: I'm trying to assign a COUNT value in one list to a column in another list (on the same site, of course). But, here's the twist - I want a COUNT of columns of a certain ...
0
votes
1answer
20 views

Calculation Overload from Excel to Sharepoint

How can I convert this Excel Formula to SharePoint? =IF(AND(F6="REG",G6>=4,G6<8),0.5,IF(AND(F6="REG",$G6>=8,G6<=16),1,IF(AND(F6="HDY",G6>=4,G6<8),1,IF(AND(F6="HDY",G6>=8,G6<16)...
1
vote
2answers
32 views

View only latest added items if item already exists (same name)

Need some help figuring out how to go about this! I have a list, people will add items to it, sometimes with the same title (which is correct). We then group these items by the column 'title' on the ...
0
votes
1answer
136 views

Compare times in calculated column

I want to compare the time from a column called "Date and time" (datetime format) with a fixed time value. I have created a calculated column for this. =IF(AND(TIME([Date and time])>TIMEVALUE("06:...
0
votes
2answers
239 views

Have a column pull criteria from two columns and display specific value

My goal is to have a calculated/or lookup column to display the company number if two columns contain certain information. I do not have access to PowerApps, Microsoft Forms, SharePoint Designer, ...
0
votes
1answer
24 views

Calculated column, one column is what percent of another column?

I'm having a bit of trouble figuring out the calculation in a calculated column. Here's what I've got - I have two NUMBER columns (column A and Column B). What I want is to calculate "Column A is ?? ...
0
votes
1answer
136 views

Need help to extend value to seconds

Got a calculated column with this formula: =IF(INT(Minuter/60)<10;"0"&INT(Minuter/60);INT(Minuter/60))&":"&IF(ROUND((((Minuter/60)-INT(Minuter/60))*60);0)<10;"0"&ROUND((((...
0
votes
1answer
93 views

how to Insert multiple items into calculated column from single line of text

My single line text value is Colombia|d12fd403-83ac-4982-bc2c-3efdeb86e1f1; EP|1ac55076-7d65-4846-af18-67658fdf276a;Bronswerk|a5e873d7-61b6-454c-98cd-8c30ec17604f. I want to get the output in ...
1
vote
1answer
95 views

If calculated value column exceeds 24 hours

I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00.. Is there any way to make a validation or format the ...
0
votes
1answer
94 views

How to make a calculated column blank if other columns doesnt have any values?

This is my format in the calculated formula: =TEXT([Column2]-[Column1];"hh:mm:ss") I have value "2018-12-13 10:10:23" in Column1 but when Column2 is blank the calculated column shows "10:10:23" ...
0
votes
1answer
37 views

Else If Calculated Column

Hi there I am just looking to see if this is possible ? I want to make a column such that if you choose a certain value from a choice column then it will give you another lot of values to choose from....
0
votes
1answer
74 views

Calculated Column - Sharepont

I used calculated column with "IF" & "AND" Functions, If the logic is true or fall certain comments will be appeared to users// Comments "Verification Success", "Verification Failed". When I try ...
0
votes
1answer
636 views

SharePoint Online List Calculated Field HTML Tags is not working

in SharePoint migration process we found a list having two calculcated fields. 1. Color: using if condition based on field values, field will get/Set the color. 2. Display: will display the Title ...
0
votes
1answer
79 views

Help with using Caml in rest api calls - filtering doesn't work for me

I'm trying to filter a Posts list(Blog) by month and year. I created a calculated column and used the Published Date to extract month and year. But my below code doesn't filter correctly when i use ...
0
votes
3answers
34 views

Caluclated Column If statement with Dates

I need to create a calculated column in SharePoint with a text output but it includes a date+day equation. I am getting syntax error which I believe is due to the column wanting the output to be a ...
1
vote
1answer
89 views

Calculating Fiscal Month

I've seen a number of calculations for fiscal year and quarter, but am hoping someone can help me a calculated column for fiscal months. Our company's fiscal months run from the 29th through the 28th....
0
votes
2answers
2k views

Apply the friendly date format to a calculated column in a SharePoint list

I have a calculated column [Due date] with a simple formula, =[Event date]+13, and it's set to The data type returned from this formula is: Date and Time. However, it doesn't have the Display Format:...
0
votes
2answers
166 views

If and else if in sharepoint list calculated column giving syntax error

I have two date fields date1, date2 and stores in column name result . I need the difference of the two dates to be calculated and store no of days in the result. Problem here is with two cases: ...
0
votes
2answers
1k views

I can't find a solution to use the value of a lookup column in a list, can anyone help?

I am trying to create a kind of registration tool with a Sharepoint list (next step could be to create an app), but I am struggling to get the value of a lookup column. I read a lot of forums and ...
0
votes
1answer
196 views

Cannot seem to access Calculated column in Display Template via Managed Property mapping

Here is my situation: I have a test/development site on SharePoint Online/Office 365 called TestSite3, and within that site a sub-site called TestBlog3 (a Blog site for making Posts). I want to use ...
0
votes
2answers
731 views

Calculated Column Field Date

I need to calculate date based on other column I'm using =Date(Year([endDate]),1,1) in a calculated field which needs to return data as DateTime, but it is giving me error: The formula contains a ...
0
votes
1answer
45 views

Calculated Field Syntax Error - Matrix Output

I'm quite new to this, could anyone point out why my calculated field isn't working Im trying to use a matrix to output a value of critical, high, medium or low The field Im using is ImpUrg_Total, ...
0
votes
3answers
373 views

Formula not working in Excel to move to SharePoint calculated column

I have two conditions that need to be met to return a date in another column Here is my formula =IF(ISNUMBER(SEARCH("Rejected",A2)) =IF(isblank,"","Today")) I can't get this to work, if i do them ...
1
vote
1answer
24 views

Calculated column with multiple options depending on start date of event compared to today

I'm attempting to create a column ("30, 60, 90, +") that reports if an entry is within 30, 60, or 90 days out. One field is "Start Date" and I want the field to report '30' if the start date is ...
1
vote
2answers
42 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
139 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
2answers
14 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
49 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
1answer
95 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 ...
0
votes
1answer
70 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
51 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
1answer
221 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 ...

1
3 4
5
6 7
23