Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Question related to the Calculated Column

0
votes
1answer
19 views

How create a SP Calculated column based on date comparison

I am trying to create a calculated column based on a date comparison. This should be a simple if else block condition but its driving me nuts. I have a date column called "Expiration Date" and I am ...
1
vote
3answers
17 views

How do I make a calculated field with a filter in SharePoint 2010?

What is wrong with the formula I used: =if([van]>=[today];"[Title]";"") Where, [van] is a date/time field in a calendar. [Title] is a single line of text. Any help will be appreciated.
0
votes
1answer
15 views

IF/Then formula producing error “refers to a column that does not exist”

I tried to follow the instructions I found on the site to get the CY month number associated with the 3 letter month column. IF([Month]=JAN,"1",IF([Month]=FEB,"2",IF([Month]=MAR,"3",IF([Month]=APR,"4"...
0
votes
1answer
24 views

How do you assign value to individual choices

Using: SharePoint Online How do you assign value to the following choices Low = 1 Medium = 2 high = 3 Then later on I want to be able to calculate 5 different questions for the total risk rating. ...
0
votes
1answer
45 views

How to create formula based on column value

I have a column in my SharePoint list named "Container Content." When adding a record in SharePoint you can choose one of three items in this column, it is a choice column. The three items you are ...
1
vote
1answer
24 views

How to use the ROUNDDOWN action along with an IF statement in a calculated column

I have a calculated column that is using a conditional IF statement to do a calculation.I am using a variation of this in 3 different Calc columns. The problem i have is that my amount are rounding up ...
0
votes
1answer
28 views

IF statement for date calculation

I have been trying 50 different ways to get sharepoint to display a date based on other columns. I tried breaking it down into smaller parts figuring that my IF formulas were too long or sharepoint ...
2
votes
1answer
112 views

Calculated Column IF/AND question

What did I do wrong? I need a calculated column to return the following: If [Status] equals "Pre-OPEN" then return [Date Opened]+3 If [Status] equals "OPEN" then return [Date Opened]+30 If [Status] ...
0
votes
1answer
30 views

Calulated Column with Multiple IF Statement

Ok, I know I am missing something. What am I doing wrong? Trying to write a calculated column with multiple IF statements. Here is what I have. =IF([Status]="OPEN",[Date Opened]+3,"")IF([Status]="...
1
vote
1answer
45 views

Caculated Column IF statement

Having a hard time finding this question already answered somewhere, so here it is. I am trying to create a calculated column that returns the following result. If "column 1" equals "OPEN", then ...
0
votes
1answer
23 views

How to make a column that color codes based on how old items in the list are

I am trying to make a column for my sharepoint list that is color coded based on how old items in the list are(i.e. if items are less than 1 day old there will be a green circle, less than 2 days but ...
0
votes
2answers
34 views

DATEDIFF() Not Calculating Number of Years Correctly

Using 10/1/2008 as the "HireDate" field, the calculated "Number of Years" returns 9 years when it should clearly be 10 years. Using 8/1/1988 as the "HireDate" field, the calculated "Number of ...
0
votes
0answers
23 views

Sum of multiple columns individually in a SharePoint List

I have a list with several accounts in it that have daily entries in each account. Each account is a column in my list. What I would like to do is sum to total of each column somehow. I have done this ...
1
vote
2answers
21 views

SharePoint calculated column based on Choice values of another field

I'm trying to do some automated scoring based on the values of a Choice field. The user can select more than one value. I need to SUM all the points for the various choices made by the user. Column ...
0
votes
2answers
21 views

Need help creating nested IF and LEFT formula in a calculated column

I have the following data in a text column called [Workcenter] 1 SOCS CSS SCXP SCQA SCOO SCPR I need a formula which will create the following results CC CC SCX SCQ SCO SCP I'm trying to ...
0
votes
1answer
18 views

Help with Calculated Field Formula

I need a calculated field formula to compare two dates from two fields - and display the one that is the latest date.
0
votes
2answers
30 views

Calculated Field Attempt not Working

I am in a need to get a calculated field that will accommodate the following: If Opp Type = Extension Renewal or On Contract Growth AND If TnC Change = No AND If Fin Pro = Yes Then set value to Yes ...
0
votes
1answer
26 views

Validation Formula in SharePoint List

I have a Formula and i want to ADD this condition : We can't Choose Closed Status when [Financial impact]<>"Loss",[Breach Nature]<>"Active" This is The Formula where i have to add this ...
0
votes
0answers
7 views

75% duration of 'Start Date'

Using SP 2016 with a site list where users can pick a Start Date and End Date. Included a formula where the Start Date can not be set to the past: =[Start Date]>=TODAY() Included a formula where ...
1
vote
2answers
143 views

how to update formula of calculated column using PnP in SharePoint Online

I want to update formula of calculated column using PnP or powershell. please note that i am using SharePoint Online. i tried below but its giving me error. please help. PS C:\Windows\system32> ...
0
votes
1answer
21 views

Column validation sharepoint list.Whats wrong with this formula

H All, I have a date i need to validate to make sure the user picks a date not less that todays date. I typed in this formula below ="Review Date"<TODAY() that works for the validation. but ...
1
vote
1answer
25 views

Calculated column between two date fields but if one is blank use another date field

I would like a calculation that gives the number of days between 2 dates (start date & end date) but if end date is blank I would like it to use todays date. How can I set this formula up?
1
vote
1answer
32 views

SharePoint Filters and Custom Views Total Calculations

I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column. I am trying to create a filter that will count how many ...
0
votes
2answers
55 views

SharePoint calculated column based on value of another field

I'm trying to do some automated scoring based on the values of various Choice fields: Column name is Project Choice values are Widgets1, Widgets2 and Widgets3 The scoring is based on the choice of ...
1
vote
1answer
67 views

IF Statement for Calculated Column where answer show negative number as #NUM!

I am creating a calculated formula to tell me Days Past Due and am trying to find a way to change the #NUM! to "ON TARGET". For Example: Item: A Start Date: 8/1/2018 Due Date: 8/16/2018 Days ...
0
votes
1answer
115 views

Calculating overdue status in a Sharepoint list using calculated column

Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to ...
1
vote
1answer
37 views

How to correct below calculated date field's formula for SharePoint list calculated field?

I have a date field called Holiday Date which is populated by user. Based on this date field, I have another calculated date field as Holiday Accrual Date. Now let's say if the populated date in ...
1
vote
1answer
34 views

How can I add a column in a list where I can choose several items in the list then calculate the difference between them? [closed]

as an example: I want to choose the percentage of how complete is the task ( in percentage) of an employee who works in 3 projects then calculate the difference between them. (100% - (the total of the ...
1
vote
2answers
219 views

Calculated column comparing two dates

I can't seem to get my formula working. All I need is to compare 2 date fields: The out of the box [Modified] and a custom [Published Date]. The published date is empty until filled by a workflow. ...
-1
votes
1answer
35 views

How to indicate a blank space in Column Validation?

I have a column called Machine #. There is a space between Machine and the # symbol. I think the space might be causing an issue - Sharepoint does not seem to like having a space in the Column ...
0
votes
1answer
33 views

Calculated Column Formula to hide blank values

So this is a follow up from my question yesterday as I believe I have found a work around or at least a potential one. To cut a long story short I have a list called "Team Information" this contains ...
6
votes
1answer
149 views

Calculated Column Based on Version Not Updating

I'm using a calculated column [DocumentStatus] and versioning to try and do some colour-formatting based on Approval Status. I have Major & Minor versioning turned on. Since I cannot use Approval ...
0
votes
1answer
21 views

How do I create an formula in SharePoint Online?

hope you're well; I would like to know how to create a formula for weekly in SharePoint online. For example Tax year is April 2018 but I would like weekly number to be from Tax year.
1
vote
1answer
39 views

Calculated Column Syntax nested DATEIF and ISERROR

This is for SharePoint Online I have a calculated column that takes info from 2 date columns and calculates the number of days. Some times one of these columns wont contain data. This will then ...
0
votes
1answer
56 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 ...
1
vote
1answer
19 views

How to create a calculated column formula for CPE year

I've been trying to figure out how to create a formula that will show what CPE year a user's training is in. Similar to fiscal year, which I did try FY formulas that are out there to no avail, a CPE ...
1
vote
1answer
32 views

SharePoint Online- Column Calculations Getting Total Items Missing

This is for SharePoint Online Having trouble getting column item count of empty entries. Originally I was attempting to find the total number of items missing in a column. example: Column A has ...
0
votes
1answer
129 views

Yes/No formula for Calculated Column Type

=IF(Fueler,"=Date(YEAR([Fueler Date])+2,MONTH([Fueler Date]),DAY([Fueler Date]))"," ") The type is yes or no. I would like to know if there is a way that if no is chosen, it would leave the ...
2
votes
1answer
41 views

How to design calculated column formula for multiplication based on nested IFs?

One of the SharePoint forms I am working with, i have two columns: !. Choice Column with choices: 2.5 ,3,4 and 6. The second column is called Quantity of type number where user enters a value in ...
1
vote
1answer
152 views

SP2013 - Formatted number column

I have a list where a text column is created for people to enter ID numbers. These ID numbers are six digits long, and numbers-only (no letters, no symbols, etc). I noticed that people were entering ...
0
votes
2answers
47 views

Difference Between 2 Dates (number of hours beyond 24 hours)

Trying to get some working syntax for calculating the difference in hours between 2 dates, Start Date [9am] and Due Date [5pm] for example. =TEXT([Due Date]-[Start Date],"h") This yields the correct ...
0
votes
1answer
27 views

If condition in calculated column

I have a small problem to solve and I hope you guys can solve it easily. So currently I have a calculated column which calculates the value but only when the status is available, so it looks like this ...
1
vote
2answers
98 views

SharePoint Calculated Field (DATEIF)

I'm using SharePoint 2010. Right now I have a calculated column which displays in days the difference between ColumnDate1 and ColumnDate2 as follows: =DATEDIF([ColumnDate1],[ColumnDate2],"d") But ...
0
votes
2answers
204 views

Format a single line of text using JSON

I have a single line of text column in a sharepoint online list that is being populated with a dynamic value added by a workflow (the value is a url + the current created item ID added to it). And as ...
0
votes
1answer
19 views

Column requires refresh upon saving

Good morning, I have a column with the following calculation: ="PX-"&CONCATENATE(REPT("0",3-LEN(ID-6)),ID-6) I had to use 6 to offset the ID number to provide a PX number. The problem is that ...
0
votes
1answer
21 views

Help with SharePoint calculated columns

I am trying to get a calculated column to work, I have the first part working fine =IF([Week Day]="Monday",[Week Ending]-6) So if weekday is Monday then take 6 from week ending and that is todays date....
0
votes
1answer
26 views

To many Parens on calculated field?

Am I overdoing it with parens? =IF((app_pr_apr01_status=""),"",IF((app_pr_apr01_status="approved"),"approved","pending")) Basically if app_pr_apr01_status = "" then field = "" if ...
0
votes
0answers
84 views

Calculated column to get data from current site URL

From this site /sites/clients/lku1055/LU1914/SitePages/Default.aspx which is not fix in my site collection (it's the URL of the current subsite), i want to get only the value of "LU1914" in this ...
0
votes
1answer
34 views

SP List dropping date format

I have a sharepoint list that has a timestamp in one of the columns. I'm adding the timestap via MS Flow. I need the format to be yyyy-MM-ddThh:mm:ssZ (so i can compare later in a REST call) but ...
1
vote
1answer
27 views

Calculated Column Generating before Other Columns?

I am trying to create a unique identifier using a combination of a few letters and numbers, for example: abc1000, abc1001, abc1002. The text will always be the same and the number is based upon the ...