Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
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. ...
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 ...
2
votes
1answer
35 views

Help with Traffic Light SharePoint Calculated Formula

I am wanting to create a column called "Traffic Light" on an existing SharePoint Library. Column Name = Traffic Light Data Type = Single line of text Formula: ="<DIV style='font-weight:bold; ...
1
vote
3answers
44 views

I want to display a blank field in the calculated column if both the reference fields are blank

I want to display a blank field in the calculated column if both the reference fields are blank, but SharePoint displays the default date as 30-Dec-1899. Formula I used in Calculated column: =IF(...
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 ...
0
votes
1answer
15 views

Giving one of two options

I am really new to all of this, but I'm trying to edit a column with the following: =OR(LEFT([Ticket Number],6) ="TASK00",LEN([Ticket Number])=0) where the user is required to enter their ticket ...
1
vote
1answer
38 views

Replace More Than One Comma Formula

I am trying to replace more than one comma from a single line of text field with an underscore, or some other symbol, but I want to replace it if a certain criteria is met - if the value in the field ...
0
votes
1answer
27 views

Calculated column to determin a due date of a record

I'm looking for some help. I'm trying to setup a calculated field to determine a due date of a record. The due date needs to exclude weekends, and also is dependent on two addition columns. ...
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
2answers
33 views

incremental number at text string for use in calculated column

I need to create a unique ID number of each new project in the follow format 00-0000-000000 where the middle four digits are a number that increments by one for each new project. I have a list called ...
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
1answer
22 views

Sharepoint list, Display a link

How can I display a hyperlink within a Sharepoint list "please follow this link: https:" This is just for sharepoint list, no 3rd party apps or infopath, also I'm not very technical so please ...
0
votes
1answer
13 views

Calculated Column based on Date

I am looking to return a calculated value based on a column named Date, I have three options I need to consider: If Date is between today and next 6 days return A If Date is more than 6 days ahead ...
2
votes
1answer
61 views

Replace comma with an underscore calculated field SharePoint Online

I am trying to replace a comma from a single line of text field with an underscore(this I managed to do), but I want to replace it if a certain criteria is met - if the value in the field contains a ...
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
38 views

Less than symbol in formula causes error in calculated column when applying site design

I'm producing a site design script for SharePoint Online in PowerShell using Add-SPOSiteScript as per these instructions, and I can create the script and add it to a site design without any errors. ...
0
votes
1answer
11 views

Using DATEDIF to convert days to month not working

I can calculate the days between two dates by doing =[Due Date]-[Start Date] and that works. But I want to calculate how many months are between the two dates. I found this formula =DATEDIF([Start ...
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
1answer
21 views

SharePoint Calculated Formula

I have 3 columns... "CEO" + "President" + "Vice President" The 3 columns are using Choice field YES or NO (I tried and could also use drop down column Yes/No). The CEO or President or VP will go to ...
0
votes
1answer
18 views

SharePoint Calculated Column to Show Date Help

I have a column "Status" and when "Completed" is chosen from the dropdown, I'd like a calculated column to show the date of that day. Is that possible with an 'If And" statement?
0
votes
1answer
37 views

Pulling info from one of several columns

When documents are added to my library, one of 4 approval workflows runs based on the metadata entered on the item (if the document is for Sales, the Sales approval workflow runs, etc). I would like ...
0
votes
1answer
36 views

How to check for empty due date in the below calculated column formula

I am using below calculated column formula for group by: =IF(Frequency="As Requested","G. As Requested",IF(DaysDifference<0,"A. Overdue",IF(DaysDifference<=7,"B. 7 Days",IF(DaysDifference<=...
1
vote
1answer
27 views

List View using a calculated Column Sharepoint 2013

I have a list view I'm trying to set up using a calculated column to return yes or no by calculating dates. The user enters a date in a form, and the column should reference the created date, ...
2
votes
1answer
47 views

Working with time in calculate columns

I am working in a calculate column that should calculate the time minus x minutes based on another date-time column. I have a start date column of type date-time and I need calculate that time minus ...
0
votes
1answer
20 views

How to change the order of group by column in sp list view

I have a calculated column created in one of the Sharepoint list, here is the formula: = IF(DaysDifference<0,"Overdue",IF(DaysDifference<=7," 7",IF(DaysDifference<=15,"15",IF(DaysDifference&...
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
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
50 views

IF statement with text field isn't possible?

Trying to do formula =IF([FIELD1]=[FIELD2],1). When I try to save the formula it gives me syntax error. Is it possible to achieve this with text? The reason behind that is if texts match it would ...
1
vote
2answers
66 views

Sharepoint IF Statement

In my sharepoint list, I have a workflow that updates today date on a scheduler at 1 AM. When new records are generated Date 2(Create time stamp) is by default a later time than today date. So as an ...
0
votes
1answer
27 views

Formula to Round

Currently in sharepoint what I have is a formula, that when Today Date-Create Date, gives me a difference of 205.55555 days. How can I change this formula to round the number to 206? =IF([Current ...
2
votes
2answers
68 views

SharePoint Calculated Column depending on future date

I'm trying to create a calculated column which will return a specific name based on the date in another column. If the 'week ending' column date is within 28 days, I need the calculated column to ...
6
votes
0answers
96 views

Formula in spreadsheet being converted to a custom list

I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list. The spreadsheet contains the following columns: Received - This will be a number column with 0 decimal ...
1
vote
0answers
32 views

Need to count entries

I am looking to make it so that each item in a list has a column that shows how many total items there are in that list that share the same value in a column as that list item. If that makes sense. To ...
1
vote
1answer
30 views

Sharepoint Validation Column

I am trying to write a validation formula with the sytax below. but it is throwing an error in SharePoint. =  IF(  AND([QC Valid Call (Yes/No)]="N/A",[QC Complaint (Yes/No)]="N/A",[QC Complaint Risk ...
0
votes
1answer
33 views

Complex calculated column in SharePoint

we have to create a calculated column from a string that can be of the form A01 (letter + 2 digit number) or it can be 2 letters plus number, as in AA1 the logis to use the ASCII codes of the letters ...
0
votes
2answers
29 views

Adding Column Total

Good Morning; I have a Custom List with a single column recording costs. I want to add the entire column (vertically) to give me a total. So far I have only been able to find advice on adding across ...
0
votes
1answer
51 views

Showings days past due and days until due in same field

=IF(ISERROR(DATEDIF(NOW(), [Renewal Date], "d")), -DATEDIF([Renewal Date], TODAY(), "d")) I am using the formula above and this is correctly showing me the items that are past due and for items that ...
0
votes
2answers
36 views

Calculated Formula for Finding three diferent results

I am working on a calculated formula based on my [Tracking Number] column to get the following results: Find "Andrews" return the result "ANDREWS". Find "Bolling" return the result "BOLLING". ...
0
votes
1answer
27 views

Calculating a due date based off two columns

I have an [assessment] and a [reassessment] column and I want to calculate the new reassessment due date. If the [assessment] date is blank then I want the result to be blank. If the [assessment] ...
1
vote
2answers
32 views

Calculating Time Duration

Working within SP, I have two columns Tech Checkin and Tech Checkout with a third column titled Visit Duration. The tech checkin and check out columns will contain a time only and are set as single ...
1
vote
1answer
34 views

Calculated Date formula not updating?

We have a Custom List in SP Online which pertains to parts needing to be inspected. Our list has the following fields: LAST-INSP: a manually entered date showing when the part was last inspected. ...
1
vote
2answers
55 views

IF Statement for SharePoint calculated columns comparing months

I'm Trying to display dates in a calculated column in the format of "DD - DD Month Year" (05-10 August 2018) or as "DD Month - DD Month Year" (30 August - 03 September 2018) if the Months are ...
1
vote
1answer
43 views

Need Assistance Updating an IF/THEN Statement

I have this calculated column formula for stoplights on my SharePoint list and I need just a little help updating/tweaking this particular formula. IF/THEN statements are not my forte. =IF(OR([...
1
vote
1answer
11 views

Date caulculation based on result of drop down column

I am trying to assign a due date based on the outcome of a column. I have a drop down on a list with the choice Complaint or No Complaint called Related to Complaint? I am trying to set a due date ...