Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
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([...
0
votes
1answer
24 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. ...
0
votes
1answer
14 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 ...
1
vote
1answer
12 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 ...
0
votes
1answer
720 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 ...
1
vote
0answers
26 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. ...
0
votes
1answer
615 views

Copy to Clipboard Button in a Calculated Column (SharePoint Online)

I have a Text field called urlText in a Document Library List. Everytime a document is created, a workflow populates this field with the URL of the Document. I want to make a calculated column/button ...
2
votes
1answer
35 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; ...
1
vote
1answer
37 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 ...
1
vote
1answer
606 views

Calculated Column - Choice Field

I'm just going to try and see if this is possible. I have a Choice Column that has three scheduled work shifts for employees to choose from. My supervisor wants the time selections to schedule that ...
0
votes
2answers
829 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/...
1
vote
3answers
44 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(...
1
vote
1answer
38 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 ...
1
vote
2answers
30 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 ...
0
votes
1answer
15 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 ...
0
votes
1answer
27 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. ...
0
votes
1answer
23 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;#...
1
vote
2answers
33 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 ...
1
vote
1answer
882 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
3answers
30 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(...
0
votes
1answer
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 ...
0
votes
1answer
22 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 ...
1
vote
2answers
800 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
1answer
13 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 ...
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
2answers
832 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
60 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
34 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
38 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
11 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
688 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
94k 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
658 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
26 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
21 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
72 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
925 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
25k 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
47 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
36 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
20 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
753 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
40 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
40 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 ...