Stack Exchange Network

Stack Exchange network consists of 175 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

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

1
vote
2answers
794 views

Calculating the week within Fiscal year in calculated field

I have been asked to make a list that contains a calculated column containing the week number within a fiscal year starting on 6th April 2015 (Monday) So for example, 6th-12th April would be week 1, ...
2
votes
1answer
25 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
30 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
28 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
10 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 ...
2
votes
1answer
630 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
39
votes
7answers
91k 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 ...
1
vote
1answer
614 views

SharePoint 2010 using REPLACE and FIND functions multiple times in a calculated field

I'm working on a SharePoint 2010 site where I have a field which contains three letter characters which are separated by a hyphen e.g. AMO-SMF. I have created a calculation which can FIND and ...
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
21 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
18 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
68 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 ...
0
votes
1answer
745 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 ...
3
votes
6answers
24k 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?
4
votes
1answer
3k views

How to filter tasks for previous calendar month

How to setup view, that would show all "Tasks" for previous month ? I can find first and last day of previous month. End of previous month: End_of_previous =DATE(YEAR([Activity Date]),MONTH([...
2
votes
1answer
44 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
668 views

How to Set Specific Date and time in Field of SharePoint List

I have a requirement where we need to create a view in a sharepoint to filter items created after 4pm on Friday until next week 4pm on friday. This is what i have accoimplished so far. Created a ...
0
votes
1answer
31 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
26 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
18 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
709 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
762 views

SharePoint 2013 calculated column multiple if statement error

can you please help me evaluate what is wrong with the if statement below, i need to use it in a SharePoint 2013 calculated column, but I keep getting an error. =if([Today]-[Last Reviewed Month/...
0
votes
2answers
37 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
36 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
62 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
39 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
59 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
799 views

Format DateTime field in calculated column display in browser timezone

I want to format my [Start Time] column as a short date. I created a calculated column and employed the TEXT() method like so: =TEXT([Start Time], "MM/DD/YYYY") However, it appears that this is ...
0
votes
1answer
36 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
297 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([...
0
votes
2answers
768 views

SP2013 : Overriding Thumbnails column in PublishingImages library

I'm really stuck with this one, so if someone has a little time to help me on this... What i want : I have a pictures library in a site. It is even a PublishingImages library. a lot of my images are ...
0
votes
2answers
1k views

Referencing Choice Field in Calculated Columns

I have a question regarding Calculated Columns. I have a Column Called "NextMileStone", this column can contain "PM010", "PM020, "PM040", "PM070", or some other choices that would be the "else" ...
1
vote
3answers
37 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
47 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
53 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
26 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
62 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
95 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
1answer
12k 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
28 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
27 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
32 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
37 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
26 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
34 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
30 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 ...