Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0
votes
1answer
25 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
288 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
101 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
74 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
2k 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
117 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
471 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 ...
0
votes
1answer
3k views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error or ...
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
65 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
435 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
153 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
65 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
990 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
71 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
611 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
17k 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
413 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
99 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
351 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
192 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
260 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
187 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 ...