Questions tagged [calculated-column-formula]

Question related to the Calculated Column

546 questions
Filter by
Sorted by
Tagged with
17k views

Calculated Column with ISBLANK

I am trying to obtain a calculated column with ISBLANK =IF(ISBLANK(AuthorTxt) , Title , Title + " " + AuthorTxt) as suggested here but I get a syntax error or not supported formula message. Why ...
511 views

Formula problem for Calculated column to display 1 or 0 based upon Yes/NO column

I am attempting to create KPI's for a column named "Template Received" (YES/NO drop down selection) based upon a Calculated Column that either turns the YES into "1" or the NO into "0". I am having ...
98 views

Calculated Formulas

I have set up a calculated formula field to calculate the date between a start date and a specified period of months to calculate a renewal date where we have the information. My problem is that ...
80k views

Creating a Status column (IF statement/calculated column)

I'm developing list for managing a project with 11 columns each representing a project milestone. We'll call them A,B,C...K. "A" representing a status of "Project Started" and K representing "...
185 views

SharePoint 2010 - specific day before date

What I would like is a calculation that would take return the value of the Thursday before my [TargetDate] value. If it is on a Thursday, it too has to be the Thursday before. This is to make sure ...
812 views

Multi Column IF Statement or workflow solution

Lets say 30 Columns and i need a calculated Column that says IF any of the 30 columns equals yes then it equals needs help, if no do do nothing. Is there anyway to do this. Or a workflow that does the ...
60 views

SharePoint List formula

I need help on below list. Pur No. Stock Qty, Sold Qty, Balance Qty. 001 500 First time when user enter the sold Qty it will work (Stock Qty - Sold Qty = Balance Qty) so if sold Qty is ...
98 views

Calculated column colours

I have a list with a column called Client Satisfaction which is a choice field with the following 1 2 3 4 5 6 7 8 9 10 I would like a calculated column to make any number between 1,2,3,4,5,6 red, 7 ...
34 views

column formula help

I've asked a question a couple days ago, wich gave me the answer =IF( OR(INT(A)+INT(B)+INT(C) = 3, INT(A)+INT(B)+INT(C) = 0), "Accepted", "Not Accepted" ) But that only works if they have to fill ...
75 views

Lookup in SharePoint

I'm using Sharepoint 2010. I have a List "Discipline" with 3 columns Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2 A A1 ...
2k views

DATEDIF statement in SharePoint not working properly

I am trying to calculate the amount of days between two dates but my formula doesn't seem to be working properly. It's as is the function is ignoring the years in the dates. My function is as follows, ...
6k views

How to update calculated column on a daily basis without admin rights?

I am running SharePoint 2013 and have a column that is supposed to determine whether or not each phase of a project is late. I am using the NOW() fucntion, which, of course, does not update ...
311 views

Calculated Field to index a String

How do I get the substring ABC from following string Hello(ABC). I used right and left function with no success
41 views

Validation Formula

I need help with a formula that will return true only when ( category <> "red" ) OR ( category = "red" AND EmployeeName - a people picker field - is not empty ) Thanks very much !
27 views

Display the column IDs for a column having same dates

I have a list with date column. Items having the same dates should store the IDs together. For eg: Item ID 1,12,15,etc. has the same date,then a column in these items should store all these IDs. ...
2k views

using [Me] as formula in column gives me current user login name. help me out if we can get the user name instead of login name.
4k views

the IF(OR) statement

I am trying to nest 6 IF(OR) statements in SP 2007 for a calculated field in a list - But it seems as if it is getting too long, and I get the syntax error thrown at me. I tested half of the length ...
446 views

Display Sum for Multiple Columns

I have a list with four columns to track different types of commissions (agent commissions and broker commissions): Agent____Amount____Broker____Amount John_____\$50________Henry_____\$50 Henry____\$...
27 views

Caluclated Field/Formula: Automated Month Counter

I have a "Start Date" field and a "Months in Process" field. Upon changing the start date, I need the "Months in Process" field to start ticking from 0 and increase in increments of 1 month. Everytime ...
310 views

Can MIN and ISBLANK be used together in a calculated column?

I have a custom list that displays the expiry date of Certificate 1 and Certificate 2. Candidates must have both to be considered Certified. The Certification expiry date is the earlier of the two ...
3k views

“IF” Statement Help

I've asked this over at Stack Overflow (believing it to be a replacement for Experts Exchange), but it seems to be mainly for software developers: This is probably a simple one for some you you wizz ...
114 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
75 views

Calculated Date after 3 years

Can anyone please tell how to get the calculated date after 3 years from current date. I have tried different combinations none is working =TEXT(YEAR(Created)+3,"MM/DD/YYYY") It returns 07/06/1905....
3k views

Folder name as calculated field

I've created a Library which consists of two Folder Content-types. Customer Prequalfication I'm looking to create a calculated column in the Prequalfication folder content-type which fetches the '...
119 views

Validate entire column with condition

I have a list that has a column which is an integer. Is it possible when selecting a number to validate if this number has already been chosen in the list. For example List Title Order ...
2k views

DateTime calculated Column using Formula

I have a column Birthday which contains the date of the user's birthday. I would like to create a calculated column to hold the user's next birthday. For instance, if I wanted to know the birthday in ...
2k views

Adding the digit “0” to a number in a list field

I have a custom with a field requiring to put an 8 digits number in it. In some cases when the number starts with a "0" SharePoint ommits the first "0" and display only the rest, so, a number with ...
485 views

Content Type IDs help

I have 2 Content Types, A and B. I am trying to create Content Type ID's(not proper ID's) and completely separate from the ID already in the list. I am creating them as a calculated field but I cannot ...
4k views

How can i find the days, hours and minutes difference between two columns in a calculated column

I want to create the functionality of this formula which works in excel =Text([end date]-[start date],"d:h:mm") in a sharepoint calculated column. It works with h:mm, but when I include the d or D I ...
68 views

SharePoint Calculated field forumla

=IF(([ATP Type] = "Tin", DATE(YEAR([First Production Date]), MONTH([First Production Date] + 4), DAY(First Production Date))), (IF([ATP Type] = "Film & Tray", DATE(YEAR([First Production Date]), ...
544 views

Calculated column shows the value of another column, how in SP2013?

I have sharepoint 2013 portal. I have a list with some columns. Now I would like to add a new calculated column. In this column I would like to show the selected item in another column. This other ...
157 views

SharePoint 2010 help with Calculated Column formula

I have a SharePoint 2010 Consensus column that weights the values of six potential risk raters. My column names are [risk1], [risk2], [risk3], [risk4], [risk5], [risk6]. Any risk rater who rates an ...
70 views

Using field [year] in calculated column issue

I have an issue with the calculated field. Basically in SharePoint 2007 I have my field called Year, so this Year I would like to use in another calculated field. So I create the field and put there ...
1k views

Calculated field with library folder name

I have a library (e-amil enabled) with e-mail with attachments and I need to make a calulated field using the e-mail subject. The problem is that the calculated field shows only when I drill down the ...
72 views

How exactly does =[Me] work?

I've read that in 2010, using 'volatile columns', like [Me], isn't encouraged. Though this functionality is needed as a default value for a column separate of Created By or Modified By. However, when ...
613 views

Sharepoint 2010 Nested If Limit

In SharePoint 2007 the limit for the number of nested IF statements was 7. On the 8th SharePoint would return and error. On my 2010 site I made an error and added 8 nested IF statements and there was ...
2k views

Calculated column: Lookup

Say I have a Date/Time [Date] column and a numerical [Value] column. I am creating a calculated column. I need a formula that will find the row with the most recent date in the [Date] column, then ...
1k views

SharePoint 2007 calculated column formula: Syntax error

I have list with a bunch of yes/no checkbox columns. I'm trying to create a column that counts how many fields in the row have the value 'Yes'. I found an inelegant formula that is supposed to do just ...
20k views

concatenate two List calculated columns into one

I am new in SharePoint so please forgive me if I am not using the right terminology. I have a list with several columns (some are calculated columns) and I was doing fine until I hit my column ...
482 views

Extract data between parenthesis in calculated value field

I'm using SharePoint 2007 and I would like to extract data from parenthesis from another column to a calculated field in the same list. For example: Column named "Team", value "RED (Mark, John, Lisa)"...
106 views

Problem Applying a formula to a column in via additional column settings

SharePoint Version is SharePoint 2007 standard Scenario: I'm trying to apply a forumla from within the additional colum settings of a date/field data type. In particular, one that'll return the text ...
2k views

sharepoint 2013 calculated column brackets disappear

I want to add an additional ID column and it should begin from 1. for this, i write a code to calculated column like this; =IF([ID]>200;[ID]-200;"OLD ID") this works fine, but when i add a new ...
355 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
201 views

Calculated value formula

I need help with the formula for the following problem. I have a list where you fill in a number of ordered items, and another column where you fill in how many of the items that are receieved. Lets ...
269 views

Formula for Calculated Value

I have two columns (for example column A and column B) with the type of information as choice. When i select value in column A then column B should show values related to column A only. Other values ...