The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
40
votes
7answers
96k views

How to use Today and Me in Calculated column

I want to use a combination of Today and Me in SharePoint 2013. I am trying it in Office 365 it gives me the below error Calculated columns cannot contain volatile functions like Today and Me. Can ...
0
votes
1answer
2k views

sharepoint calculated column to round a number

I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be ...
0
votes
1answer
31 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
22 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
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 ...
2
votes
1answer
76 views

3rd Tuesday Calculated Column not working when there are 5 weeks in the month

Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month. I have one column called Current Patching Date (date/time field) - stores a date I ...
3
votes
6answers
27k views

Days since list item was created

I have a list. When an item is created it is automatically assigned the created date. I would like to add a “days open” column. "Days open" being the number of days from the created date to today’s ...
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?
2
votes
1answer
48 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
37 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
3answers
6k views

how to get sum of a column in sharepoint 2013 list

Not sure if i would get any answer from here. I have a column number and title text. The data would look like this: Title Paid ---------- Jacob 200 Patrick 100 Jacob 100 Patrick 300 What i would ...
0
votes
1answer
21 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
795 views

Sharepoint - Calculate Remaining Workings Days - Date to Today

I am trying to work out how to calculate the remaining works days between a set date in a sharepoint column and Today. However the below formula brings back a syntax error in sharepoint. Can someone ...
0
votes
2answers
42 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
43 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 ...
1
vote
1answer
64 views

calculated column IF OR

I'd like to create a calculated column that helps me segregate options based on a previously selected choice. The essential argument will be the following that if the user selects Alignment A then ...
0
votes
1answer
42 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
2answers
74 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 ...
0
votes
1answer
41 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
3answers
378 views

Getting error when creating calculated columns

I am trying create a simple calculated column, but I am getting an error: The formula contains a syntax error or is not supported The formula looks like: =DATE(YEAR([RevisjonsDato])+1,MONTH([...
1
vote
3answers
53 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
52 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
72 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
32 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
79 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
97 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 ...
2
votes
1answer
14k views

Calculated Field with formula DATEDIF

Im working with a calculated field and using a formula to retrieve the difference of the days between two dates, DATE1 and DATE2, my simple formula is: =DATEDIF([DATE1], [DATE2],"d") It works fine ...
1
vote
0answers
33 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
34 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
1answer
70 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
30 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
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
2answers
57 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
40 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
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 ...
1
vote
1answer
58 views

How to get a count of values in field using calculated columns

I have a calculated column and would like to get a count of all the occurrences of "true". So the first row shudl return 3 and the next 2 etc.. Can this be achieved using calculated columns Thanks in ...
0
votes
2answers
17 views

Calculated Forumla - help joining syntax

I'm not sure if it can be done, please note I am not a novice, I am trying to join multiple syntax for a calculated column. I have column 1 as 'state' its values are either California or New York ...
1
vote
1answer
18 views

Help with Calculated Formula

I'm trying to create a calculated field column but its not being accepted. I'm trying to write a syntax for if 'column 1' = 'value1' and 'column 2' does not equal 'value2' then return 'employee name'. ...
1
vote
1answer
27 views

Calculated Column returning Undesired Result in one of over 300 list items

I have a calculated column in a Sharepoint List that is simply adding up 5 other columns with the following formula: =RWDPeriod1+RWDPeriod2+RWDPeriod3+RWDPeriod4+RWDPeriod5 The problem is that ...
5
votes
1answer
132 views

Easy way to write a correct formula!

Is there any easy way to write and validate a SharePoint calculated field formula? I am trying to find a formula builder like CAML builder!
3
votes
3answers
1k views

Concatenate two dates to one column

I am pretty basic user of SharePoint 2013 and I have this problem: I have to create a calculated column with two dates in them to look like this: From 21/2/2016 to 5/3/2016 but whatever I try, the ...
2
votes
2answers
65 views

Calculated column displaying “#Name?”

I'm trying to display KPIs that show how long a list item spend in each status. Column name = Time In 5. =IF(OR(ISBLANK([Date entered 6. ]),ISBLANK([Date Entered 5. ])),"No KPI dates",DATEDIF([Date ...
1
vote
2answers
28 views

Formula of Calculated Column

I want to make a formula to my calculated column : If the DD Rating is High => Add 3 months to the [DD Sign-off Date] If the DD Rating is Medium=> Add 6 months to the [DD Sign-off Date] If the DD ...
3
votes
1answer
181 views

how to get minimum dates in a sharepoint list

How can i get a minimum date of some columns with dates field.I know i can use the min function(formula) with numbers but not with dates. is this possible using calculated columns if not would i be ...
1
vote
2answers
5k views

Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")...