# Questions tagged [calculated-column-formula]

Question related to the Calculated Column

548 questions
Filter by
Sorted by
Tagged with
13 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 ...
75 views

### If A completed move to B, and if B completed move to C

The scenario I have written supposed to work like below... A has 4 multiple choice options, (Completed, Suspended, Blocked, Cancelled) B has 4 multiple choice options (Completed, Suspended, Blocked,...
32 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(...
99 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 ...
29 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 ...
45 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, ...
509 views

### Lookup Column in sharepoint with free text (No dropdown)

I have a free text of employee number in task form (Linked to form), when employee number is entered, I want to auto populate name and employee department. I can have source data in excel or separate ...
120 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 ...
22 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 ...
30 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 (...
53 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 ...
87 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 ...
232 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 ...
35 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. ...
116 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 ...
27 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 ...
52 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. ...
44 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 ...
312 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; ...
80 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(...
40 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 ...
19 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 ...
46 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 ...
53 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. ...
56 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;#...
344 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 ...
35 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(...
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 ...
37 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 ...
17 views

### Perform column Calculation only when particular field is updated?

In a custom list, I have a choice-type column named "STATUS" which has the following available choices: To command commanded received I also created a Calculated column named "CHANGE" with the ...
19 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 ...
146 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 ...
185 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-...
107 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. ...
23 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 ...
55 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 ...
24 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 ...
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?
38 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 ...
47 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<=...
34 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, ...
54 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 ...
39 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&...
54 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 ...
168 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 ...
50 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?
50 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")) ...
63 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 ...