Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
13
votes
1answer
779 views

Save Calculated Column Formula in Language Localized notation using REST or JSOM?

[multiple blogs/posts out there noted the issue, no solution was ever published] What is required to save a Localized Calculated Column Formula using JSOM/REST? I am injecting the script below into ...
1
vote
1answer
85 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
29 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
343 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
3answers
288 views

SharePoint List Column Conditional Calculation

In a new list item form,the user wants to have a column to display month & year(pre populated on opening the form) based on the below condition. "1. If the current date is > 15 ,then that column ...
1
vote
1answer
68 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" "...
0
votes
2answers
262 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 ...
1
vote
2answers
978 views

Calculated date column in using multiple IF-Statements

Currently, I am creating a calculated column called Next Meeting Due This column is linked to 2 other columns: Meeting Frequency -> (which can be monthly, 6 monthly and annually) Last Meeting ...
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
426 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
581 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)...
0
votes
1answer
150 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
81 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
3answers
6k views

Formula to show differens between dates without weekends and holidays

If anyone know formula without code in SharePoint 2010 to show differens between dates without weekends and holidays, I'm trying to find solution but no result so far ... I will be veru gratefull for ...
0
votes
1answer
141 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
44 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
72 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
74 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
2answers
135 views

Custom Calculated Column to sort dates based on entry date

**Edit: Hi, I know it has been a while since this was answered but I am having some issues with this formula. Since the start of the year it is giving me two different week numbers for each week. This ...
0
votes
2answers
80 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 ...
0
votes
1answer
424 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
148 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
174 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] &...
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 ...
11
votes
3answers
2k views

Sharepoint calculated column shows year with comma

I am new to SharePoint and I am trying to display year with the help of calculated column. However, the resulting year is displaying with comma i.e. 2,016 instead of 2016. Is there any easy way of ...
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
50 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 ...
1
vote
3answers
2k views

Count not updating in calculated column

I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula. =IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d")) ...
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
142 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
574 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
282 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
916 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 ...
0
votes
3answers
9k views

calculated formula for date in sharepoint

I have a date field "Start date" and want to create calculated field based on below condition If start date is less than current date enter value "Progress" If start date is greater than current date ...
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 ...
1
vote
2answers
917 views

sharepoint formula to send email to user

Can anyone help me with sharepoint formula? What I am trying to do is I have a list column and it has list item Column Name: user Type: Choice Type of Choice: List of names (Eg jack, bob, ...
0
votes
1answer
136 views

How to add an image in a calculated list column

I want to use and image instead of a text in a field. see this image The edit column its a calculated column. If users click on it. It will opens the editform.aspx. So i want to use an image instead ...
1
vote
2answers
105 views

Calculate time difference with 4 date time columns

I have 4 dates In this format dd/mm/yyyy,hh:mm. Date1, Date2, Date3 and Date 4 The formula is: =(Date1+Date2)-(Date3+Date4) the results must be in hh:mm At the moment I have 3 columns, A =TEXT([...
0
votes
1answer
32 views

Can someone spot the error please

I am trying ti create a calculated column where it will add the vale "has been completed" if the approval column is approved. Below are the code and screenshot of the error. Thank you =IF([...
0
votes
3answers
58 views

Nested IF to Calculate Complete or Incomplete

I have several columns on a list that are radio buttons for either "Completed" or "Not Applicable". I need to draw the status of an item based on if those columns have data in them. Someone may choose ...
0
votes
2answers
466 views

how to create history column?

I have implemented a document library in which a person assign a document to review to a responsible person. He assigns it selecting his name from the Responsible column. Then an email goes to that ...
3
votes
2answers
280 views

Can someone spot an calculated column error Please?

I am trying to create a calculated column where 'Today Date' is another date column. The first two block are working fine till the [Enter time]=2 condition when I add other two it says syntax error. ...
1
vote
1answer
382 views

Calculated Field with formula DATEDIF + dispay text

I have created a CustomList called BirthdayReminder and also set up a Site-workflow which runs everyday at 00:00 to update the fields - otherwise the Birthday Reminder will stay static. My aim is ...