SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulas. They allow you to display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

Calculated columns are the SharePoint equivalent of Excel formulas. They allow you display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

The Microsoft documentation for calculated columns: Calculated Field Formulas.

The full function reference: Examples of common formulas in SharePoint Lists.

1279 questions
11
votes
5 answers

How to use calculated field to retrieve the ID of the item in the SharePoint 2007 List?

I have a calculated field in a SharePoint 2007 list. I want this calculated field to include the ID of the item but I could not find the ID column inside the "Insert Column" List box. How should I go about in order to get my calculated field to have…
Anderson Karu
  • 454
  • 2
  • 6
  • 18
10
votes
9 answers

get the month from a date column with the calculated column

I am trying to get the month from a date field with the help of calculated column. However I get this syntax error whenever I want to submit the formula: Error The formula contains a syntax error or is not supported. the default language of our…
d d
  • 223
  • 2
  • 5
  • 13
10
votes
5 answers

how to show HTML code in column?

how can i force sharepoint2007 (MOSS) to interpret HTML code instead of showing it? I have a column which calculates a yes or no (depending on other columns) within a HTML (i want to show images too). This column is not interpreted by sharepoint.…
None
10
votes
5 answers

Column calculated value to get the current date time?

I have tried using =TEXT(Today,"mm-dd-yyyy hh:mm:ss") but that only returns the 5/5/55 00:00:00, it won't give the time. How do I get both the date and time with a calculated formula?
Meyer Denney
  • 2,864
  • 8
  • 37
  • 64
9
votes
6 answers

How to use [Created By] in a column?

SP 2007, calendar list. Want to add a column that gets its default value from "Created By" but then allows that to be edited. This is what I tried: Create column Give it a name Leave type set to Single line of text Change Default value to…
None
8
votes
4 answers

Check if more than 3 hours

I need a calculated column to display "Yes" if the current time is more than 3 hours after the value of another column. This is what I've come up with: =TEXT(Today-[AddTime],"h")>3 But SP tells me this is invalid. Are there other ways of doing…
Larsi
  • 683
  • 1
  • 11
  • 17
6
votes
2 answers

Calculated column issue with if statement and yes/no field

I have seen other similar questions about calculated fields/columns and Yes/No fields, but only regarding syntax. I don't have an issue with the syntax (I think) but I can't get an IF statement to work with a Yes/No field. My formula is pretty…
Sam
  • 193
  • 1
  • 1
  • 5
5
votes
1 answer

Calculated Column with Nested IF statments

Here is my current formula that works. ="
Trisha
  • 53
  • 1
  • 1
  • 3
4
votes
4 answers

Calculated column with a Date

I am creating a list whereby I want following function: Current Day or Today - 2 days = Output Date i.e. 23/12/2010 - 2 days = 21/12/2010 Is it possible to change the current dates dynamically also? i.e. everyday the Current Day column automatically…
neo269
  • 3,175
  • 15
  • 68
  • 106
3
votes
2 answers

How to match current user to a username column?

I have a list view that should only show when an admin adds the person's username to an "allowed viewers" username column. So, I am thinking to create a calculated column that compares the current-viewing user to the username in the "allowed…
bgmCoder
  • 3,581
  • 16
  • 61
  • 102
3
votes
2 answers

SharePoint Calculated Field Limitations - Need Work Around

I have the following in a calculated field. I need to add many more IF statements but when I start adding more to the code I begin to get Syntax Error. I need a workaround to make this work. =IF(Currency="USD",[Total Cost (Local…
That-Guy
  • 31
  • 1
  • 2
3
votes
1 answer

SharePoint List Calculated column to calulate Totals

I could import the excel data shown here to a SharePoint list 2010.I imported all the columns. Let's say I have two columns. Name and Value. For Value column, I have numeric type. I need to calculate Score for Value column, which can be…
Nemo
  • 145
  • 1
  • 2
  • 5
3
votes
2 answers

IF statement, Trouble with formula

I have created a simple list where we record time spent on troubleshooting customers. But now I would like to create a simple formula for a Calculated field, but I can't get it to work. We have two hourly rates. Number of minutes times 0.75 Number…
René M.
  • 31
  • 2
3
votes
1 answer

Calculated column - Date and minutes/seconds from Modified column

In a library my calculated column calculates what date Monday is the week after a document is last Modified. =Modified-WEEKDAY(Modified,2)+8 I also want to add the minutes and seconds (not the hours): =Modified-WEEKDAY(Modified,2)+8&"…
Haz
  • 375
  • 1
  • 6
  • 21
3
votes
3 answers

Add Day in front of Date but Retain Date

One of my views groups by date, and I was asked to add the day to the front of it, such as "Wednesday October 26, 2016" or "Wednesday 10-26-2016". I've tried using a concatenate and a bunch of text fields, but no dice. Here is where I…
Joe Fedorowicz
  • 355
  • 2
  • 14
1
2 3
…
9 10