Questions tagged [calculated-column-formula]

Question related to the Calculated Column

3
votes
1answer
65 views

Yes No calculated field for closed/created in last 7 days and items open or in-progress

I would like to create a calculated field that outputs "Yes" or "No" if an item in my SharePoint list has been created in the last 7 days, closed in the last 7 days (field in status column), or 3) ...
2
votes
1answer
71 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
2answers
715 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 ...
1
vote
0answers
73 views

Calculated column based on specific elements from another site column

I have this site column in a Sharepoint 2013 list showing a few deadlines. I need to create a calculated column next to the one in the picture, that gives as a result the number of days between one ...
0
votes
2answers
277 views

Calculated column looses brackets

I have a strange problem with my calculated column. I want to build a link utilizing the ID of the entry. So I have a formula like this: ="<a href='someurl.html?id="&[ID]&"'>some text&...
2
votes
0answers
34 views

Calulated column displays html markup sharepoint 2013 [duplicate]

I am experiencing an issue with a calculated column that presently returns html markup for the purpose of KPI in sharepoint 2013. It was working well, all of a sudden it started displaying the raw ...
0
votes
1answer
449 views

Totaling Three Columns for a Balance Column in a SharePoint 2013 List

Newish to SharePoint so, hopefully, I am explaining this clearly. I want to build a simple Timesheet List where I have the following columns: Employee Name (Choice column, drop down of employee ...
2
votes
1answer
619 views

JavaScript Code in the SharePoint 2013 calculated column

I added the code below to a SharePoint calculated column in order to get today's date, and it works well, however, I will need to add another calculated column to get the date difference between "...
0
votes
2answers
773 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
1k views

SharePoint 2013 calculated column adding multiple if statement

i created a calculated column(column name"status") with a simple formula below: =if([Priority]="Low"), "Yellow", if([Priority]="Normal"),"Green", if([Priority]="High", ”Red"))) As you can see, what ...
1
vote
1answer
274 views

Help with SharePoint Calculated Field Multiple Values

I have the following formula on a calculated field that searches the value funnel status for values, then sets as live or active. Rather than search does the field contain a specific value, I would ...
1
vote
1answer
241 views

CountIF statement in SharePoint

I am trying to make something like a CountIF statement in SharePoint for the purpose of counting specific choices made in a drop down category for a calendar event. Currently, when I make a new ...
1
vote
1answer
78 views

SharePoint 2013 filter based on created date

I am struggling to construct a SharePoint formula in which I want to show items within 14 days from created date. i.e. between created and created+14<=Today.
1
vote
1answer
63 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 ...
1
vote
1answer
28 views

SharePoint 2010 calculated column getting stuck half way through the formula

Here is a formula I am using to get the RAG status to display either "Green" "Yellow" "Amber" "Red" in a calculated column, it works fine for green but when entering the data in a form the value won't ...
1
vote
1answer
340 views

SharePoint Online - Update list with row totals from another list

I have a list (ListA) that is populated by an InfoPath form, everytime a user fills in the form another row is added. Now I'm only interested in the 1 value and I want to sum each instance of 1 for ...
1
vote
1answer
64 views

Adding Multiple Columns with Different IF Statements

Essentially, I am helping to setup a SharePoint site that another department will for reviewing contracts to make sure they are correct. There are many different choice columns with "Correct" "...
1
vote
1answer
621 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
2answers
260 views

calculating date differences in custom list

I have a custom list to track audit NC closures. Due date, actual closure date, days overdue I want a field to calculate the number of days overdue the closure is. If I do a DATEDIF the formula will ...
2
votes
2answers
2k views

How do I add hours to Now() after converting it to a text value?

I have a calculated field that shows the text value of the current hour, so I'm using: =TEXT(Now(), "hh") Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to ...
2
votes
1answer
419 views

Calculated Column display in filter of list

Hi I'm using the this approach https://sharepoint.stackexchange.com/a/118213/53772 to color an field of an list e.g. =IF([Status]="red","<div style='color:red;'>red</div>","error") ...
8
votes
1answer
6k views

Filter “Modified” by previous week

Want to filter list items that were modified on last week Think pseudocode for this will be Modified >= ( [Today]-WEEKDAY-7 ) && Modified <= ( [Today]-WEEKDAY ) No matter what day of ...
0
votes
1answer
555 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 ...
0
votes
1answer
2k views

Sharepoint 2010 convert text into date

I’m trying to convert a column type “Choice (3/29/17) (4/29/17)” into a date using the code below and get a “#Value!” error in Calculated column =TEXT(DATE(LEFT(CounselingDT,4),MID(CounselingDT,6,2)...
4
votes
2answers
105 views

SharePoint Calculated Column

Im no expert but I seem to be struggling with this. I have a calculated column field called [Review Days] for which I hope to enter an amount of days that a document will need reviewing. 1 year will ...
0
votes
1answer
146 views

Random date in calculated columns

How can i have a random date in calculated columns ? I tried RANDBETWEEN(DATE(2015;1;1);DATE(2017;4;4)) which works in Excel, but not in Sharepoint.
0
votes
1answer
76 views

*Urgent* need help to create SharePoint Calculated Column

I have a SharePoint List in which one column has Account numbers like 000000123456 000012345678 C00012345 Now I have to create a calculated Column which can display the above fields as 123456 ...
0
votes
1answer
814 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
138 views

Sharepoint 2013 - Copy list Item changes calculated field value

I have a list which triggers a workflow at the end to move the form (copy > delete) to another list. The form has a calculated field I am using to give the form a specific reference number. When I ...
2
votes
1answer
43 views

Issue writing Calculated Column Formula

I've looked at this formula over and over again, but the system will not except it when I attempt to create a Calculated Column. Does anyone see any problems with it? =IF( [Approve/Reject-1]="...
2
votes
2answers
3k views

Dynamic Hyperlink via Calculated Columns Truncating at Space

I'm trying to generate a hyperlink to an item page using a calculated column. I'm 99% of the way there, but I run into issues when the title has spaces. My calculated column has the following ...
1
vote
0answers
70 views

Submitting and emailing an InfoPath quiz

I need the Submit button to email the quiz results and also submit the results to SharePoint. I first used a rule button and created 2 rules, 1 to email and 1 to submit the form to SharePoint. It ...
0
votes
1answer
72 views

formula assist sharepoint 2010

Trying to create column in list settings using calculated field based on other columns in SharePoint 2010 Using formula : =ROUND((NETWORKDAYS([Actual Start],[Actual End])*8)-IF(WEEKDAY([Actual ...
0
votes
1answer
416 views

formula to give next month and end date?

Not sure if this is possible, i have a set of given dates, and i want to an extra column to increase the given date by 13 months, is this possible? e.g 16/02/2016 ===> 31/03/2017 Many thanks
0
votes
1answer
147 views

Calculate Date with IF statement

Here is the ask: I need a formula for SP that will calculate the 1st of the next month or 1st of the second depending on the number in column titled week number. class end Date week number 30 ...
1
vote
2answers
172 views

If Statement in SharePoint Calculated Column Formula

this is my current formula(see below). Right now I am adding admendment, however I only want it to add admendment if request status - amendment but I need help with this formula =[Date Formula] &...
0
votes
2answers
78 views

How can I flag up documents in a library that are drafts (minor versions 0.1)

I would like to flag up all minor versions of documents in a document library. It's probably one for a calculated field but I am having trouble figureing out how to do it? Basically what I want is to ...
1
vote
2answers
2k views

Formatting date inside a If than statement

I am struggling to find an answer on how to format a If then statement in SharePoint 2013 using a calculated column. I need to display the word "Completed" if the date =1/1/1900 or display the date ...
0
votes
1answer
69 views

Custom Date Formulas not working properly for 2017

I have several custom date formulas setup which all worked fine in 2016. Now that 2017 is here it seems there is some miscalculation happening within the formula, but I cannot tell what the problem is....
0
votes
2answers
116 views

Formula in Calculated field is correct but doesn't refresh

A calculated field has been created within my Sharepoint library to show what items will be due for review within 21days of the current date. I understand the [Today] [Now] don't work too well within ...
2
votes
1answer
2k views

Using calculated columns to create a button for each list item that launches a Javascript function passing column values as the parameter

The Issue I have struggled create a calculated column in my SharePoint list that renders a button with an onclick event to start a javascript function while passing two column values from the list ...
1
vote
1answer
49 views

Calculated columns

I'm trying to create a calculated column that removes 7 characters from the front and 2 from the back of the title column. I can get the formulas (below) to work interdependently but when I combine ...
3
votes
0answers
102 views

SharePoint Conditional Validation / Formula

In SharePoint Online can i perform the following? I have a column to calculate the date difference between Last Visit Date and Next Visit Date. Last Visit Date is already provided, and users will ...
0
votes
2answers
136 views

Error in Calculated Column

I have list view which contains 4 columns. I have Select Country is a calculated column. The formula for the calculated column is: ="<a href='javascript:SelectCountry("&CountryCode&")'&...
0
votes
1answer
548 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 ...
3
votes
1answer
275 views

Need help with calculating a date that only falls on a weekday

I have a column named "Date received" and I need to calculate a "Date Due". The due date is 3 calendar days after received however if that falls on a weekend it needs to be the next business day. I'...
1
vote
1answer
40 views

Calculated Column Working Time with Lunch Break

I hope, someone can help me finding the error. I am working on a form in SharePoint to enter the working time. Calculating the working time without lunch is no problem, but I am running in Errors when ...
4
votes
1answer
875 views

Add a line break in calculated field with formatted date?

I am trying to create a line break within a calculated column that displays the Date in DD MM YY format. The purpose is to utilize the field in a script which is altering the list view. My ...
1
vote
1answer
78 views

Formula syntax error

I'm trying to add more than one if's (also) statements inside a formula, but it is not working because of a syntax error. What I'm trying to do is if actual sign date column is less or equal to the ...
1
vote
1answer
2k views

Help with creating a Workflow that will allow calculated field to display combination of Dropdown Field & SharePoint Generated ID as a Doc ID#

I need to create a workflow to make my process work correctly due to the order in which items are processing causing the calculated field not to update correctly, but I am struggling with creating one ...