Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
1
vote
2answers
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 ...
1
vote
1answer
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 ...
0
votes
2answers
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 ...
1
vote
1answer
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 "...
1
vote
1answer
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 ...
0
votes
1answer
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 ...
0
votes
0answers
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 ...
1
vote
1answer
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 ...
0
votes
1answer
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 ...
0
votes
2answers
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 ...
1
vote
1answer
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, ...
2
votes
4answers
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 ...
1
vote
1answer
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
0
votes
1answer
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 !
0
votes
1answer
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. ...
0
votes
0answers
2k views

how can we get the Current UserName instead of LoginName using calculated column in SharePoint 2013?

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.
2
votes
2answers
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 ...
0
votes
3answers
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____$...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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....
0
votes
1answer
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 '...
0
votes
1answer
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 ...
4
votes
3answers
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 ...
2
votes
1answer
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 ...
0
votes
0answers
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 ...
1
vote
3answers
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 ...
0
votes
1answer
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]), ...
0
votes
1answer
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 ...
1
vote
1answer
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 ...
0
votes
1answer
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 ...
1
vote
0answers
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 ...
1
vote
1answer
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 ...
3
votes
0answers
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 ...
1
vote
1answer
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 ...
0
votes
2answers
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 ...
4
votes
2answers
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 ...
0
votes
1answer
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)"...
0
votes
1answer
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 ...
1
vote
1answer
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 ...
2
votes
2answers
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 ...
1
vote
1answer
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 ...
0
votes
2answers
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 ...
1
vote
0answers
192 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...

1
7 8 9 10
11