Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

1
vote
1answer
152 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 ...
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
2k 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 ...
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 ...
0
votes
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 ...
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 ...
3
votes
6answers
24k 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 ...
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 ...
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 ...
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
9k 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 ...
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 ...
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
406 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)"...
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
186 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 ...