Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0 votes
1 answer
125 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 ...
TeddyRuxpin's user avatar
2 votes
1 answer
3k 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 ...
miklow's user avatar
  • 23
4 votes
3 answers
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 ...
Gonzalo's user avatar
  • 447
4 votes
1 answer
4k views

How to filter tasks for previous calendar month

How to setup view, that would show all "Tasks" for previous month ? I can find first and last day of previous month. End of previous month: End_of_previous =DATE(YEAR([Activity Date]),MONTH([...
Alvis's user avatar
  • 63
0 votes
1 answer
5k views

sharepoint calculated column to round a number

I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be ...
mayank surana's user avatar
0 votes
0 answers
492 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 ...
bimbob's user avatar
  • 461
0 votes
2 answers
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 ...
Nk SP's user avatar
  • 2,893
2 votes
1 answer
8k views

Add month in calculated date column

I'm using SharePoint 2007. I've a column with date in format DD/MM/YYYY I've also another column where I want to add some months to the previous date and obviously I've a column with the number of ...
Pepozzo's user avatar
  • 1,073
0 votes
1 answer
693 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 ...
Ola's user avatar
  • 4,405
0 votes
1 answer
72 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]), ...
Splunk's user avatar
  • 194
4 votes
0 answers
11k views

Calculated column formula for not equal

Hi can I use the <> operator in a SharePoint Calculated column? The following formula is accepted but I'm not sure it is supported. My requirement is: If any values equal High AND are not ...
Kms's user avatar
  • 83
0 votes
1 answer
82 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 ...
Shkipper's user avatar
  • 2,105
1 vote
0 answers
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 ...
Paolo B.'s user avatar
1 vote
1 answer
174 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 ...
Kms's user avatar
  • 83
1 vote
1 answer
79 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 ...
Christopher's user avatar
3 votes
0 answers
621 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 ...
AxGryndr's user avatar
  • 168
1 vote
1 answer
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 ...
false_azure's user avatar
0 votes
2 answers
3k views

How to stop DATEDIF calculation when Status column equals closed

I'm working on a list in SharePoin 2010. I need to know how long a job has been open before it glot closed. I also need it to count how many days it has been open if it hasn't been closed yet. This ...
Ben's user avatar
  • 3
0 votes
2 answers
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 ...
false_azure's user avatar
1 vote
3 answers
5k 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 ...
rgwaldron's user avatar
  • 771
4 votes
2 answers
25k 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 ...
user22288's user avatar
4 votes
6 answers
49k views

Days since list item was created

I have a list. When an item is created it is automatically assigned the created date. I would like to add a “days open” column. "Days open" being the number of days from the created date to today’s ...
user1438082's user avatar
0 votes
3 answers
10k 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 ...
Wilon's user avatar
  • 513
2 votes
1 answer
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 ...
AhuraMazda's user avatar
0 votes
1 answer
120 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 ...
Steven D Andrews's user avatar
1 vote
1 answer
10k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
user21296's user avatar
2 votes
2 answers
363 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 ...
meepmeep's user avatar
0 votes
1 answer
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 ...
Mr T's user avatar
  • 111
0 votes
1 answer
746 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)"...
Pepozzo's user avatar
  • 1,073
1 vote
1 answer
221 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 ...
Skon's user avatar
  • 13
0 votes
2 answers
277 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 ...
Kalpesh's user avatar
  • 113
1 vote
0 answers
209 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 ...
Amadeo Gallardo's user avatar

1
13 14 15 16
17