# Questions tagged [calculated-column-formula]

Question related to the Calculated Column

486 questions
Filter by
Sorted by
Tagged with
9 views

### calculated coluum formula error

Escalation status to be calculated as per below: Conditions: 1)if the status is "ETA Slipped" and Original ETA is > 15 days and Revised ETA is null Escalation status should be "ETA slipped beyond 15 ...
14 views

### Does Sharepoint allow IFS formula

I tested this on excel but can not translated to Sharepoint. I am trying to test for example if Column C has date that is greater than the one in column D = Submitted on time, if column C's date is ...
20 views

### SharePoint If Statement Long [closed]

I need a long statement for my calculated column to work. Basically I need it to say =IF[DeptID=201000 - Instruction],"Bob") OR =IF[DeptID=201000 - Instruction],"Tod") OR =IF[DeptID=201000 - ...
18 views

### Calculate number of days from date to today [duplicate]

I have tried and looked for the answer to calculate the number of days from a date to today's date and getting an error. Calculated columns cannot contain volatile functions like Today and Me. ...
26 views

### Display a date field in a specific format as single line of text using calculated column

I Need the Right Formula for the following Problem: I got a column that contains only date but sometimes it contains no Information. =DAY([AB])&"."&MONTH([AB])&"."&YEAR([AB]) This ...
38 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 ...
11 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 ...
24 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 ...
47 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 ...
58 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]-...
29 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 ...
47 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. ...
13 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: ...
14 views

### column formula error preventing subsite creation

When attempting to add subsite in Classic view SharePoint online, I receive - "Sorry, something went wrong. The formula refers to a column that does not exist. Check the formula for spelling mistakes ...
8 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 ...
148 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 ...
18 views

### Field Level Validation - Require Non-blanks on Numerical Fields

I have a custom SP list with a handful of non-required numerical fields. I'd like to write a column validation rule for each that would force users to enter any value >=0. Our users will be using Data ...
28 views

### IF Formula question

I am having some difficulty creating a formula in my Sharepoint List. I have a column that is a list of countries and I am trying to create a formula that will check the value of the column and spit ...
18 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)...
17 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:...
65 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((((...
17 views

### Calculated Column in SharePoint 2007 list stopped working

I have a calculated column called 'Month' which adds in the month and year when each item was last modified. This has suddenly stopped working across all SharePoint 2007 lists in our environment and ...
27 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 ...
52 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" ...
63 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 ...
45 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 ...
29 views

### SPO Calculate the difference between two dates

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula: =...
22 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....
135 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:...
17 views

### Calculated Columns in Sharepoint

I created two calculated columns to calculate the difference between Payment Date and Transfer Date, one of which is the "Duration" (between the payment and transaction) and the other is "Days Since ...
30 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: ...
27 views

### Formula IF time between ranges (Calculated column)

I have a column "SignIn" that shows the date/time of a staff sign-in. I have another column "Late Flag" that will show if they are late or not. There are sometimes multiple sign-ins/outs throughout ...
20 views

### Increment count

I have an SPO list where I want to do an event tracker. It will track if an instance happens it increments by one, and we keep tracking for a year. At the end of the year the tracker reset to 0, and ...
58 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 ...
30 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, ...
51 views

### Update multiple choice field values using Flow

Is there any way of removing multiple-choice field values from a specific column using Microsoft flow? The logic behind the columns is given below. Once A is completed, move to B and once B is ...
15 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 ...
32 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]),...
99 views

### Update Yes/No field if Date is today

I am trying to create an automated SLA field I have a "Date Requested" Field and an "Outside of SLA" field. Date Requested is formatted as a Date, Outside of SLA is formatted as a Yes/NO / True/...
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 ...
74 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,...
30 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(...
49 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 ...
27 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 ...
23 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, ...
62 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 ...
40 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 ...
20 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 ...