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.
1,224
questions
3
votes
1
answer
3k
views
Unescape HTML from list column
I've got a multiline column in a list that contains HTML. When trying to use the field in SharePoint Designer 2010, it shows it as raw HTML, instead of rendering it. So using this syntax:
<xsl:...
- 4,395
4
votes
5
answers
35k
views
URL in calculated column
Is it possible to have "clickable" URL address in (SP 2010) calculated column without any JavaScript code or Designer?
I found the way how to easily make "universal" Document ID links visible for ...
- 1,616
1
vote
1
answer
286
views
Creating 'Task Ranks' depending on user
I need to create a column 'Task Ranks' - which ranks each task/item for a user. I need it to be of lowest unique value/integer from all active tasks for that user and to serially generate the next ...
- 3,165
1
vote
2
answers
160
views
Calculating event lengths that cross time changes
I have a calculated field to work out the length of an event in days, as follows:
=DATEDIF([Start Time],[End Time],"d")
I live in the UK and we're currently on BST; so if I create an event in GMT ...
- 11
10
votes
2
answers
2k
views
How can I display a message on a list item when within X days of a date?
I'm using SharePoint 2010 and I'd like to create a column in Task List that will display a message (not generate an email: just display a field text) such as "URGENT" or "Almost Due" when the date is ...
- 121
2
votes
2
answers
2k
views
Create a calculated column to diplay midpoint between 2 dates
Any help greatly appreciated.
I'm using SharePoint 2010, typical TASK LIST. I want to put in a start date and a a due date but have a field (column) that displays the MID WAY POINT between those two ...
- 121
2
votes
2
answers
167
views
calculated field help, moss 2007
I'm trying to build a calculated field with the following condition:
if [field1], [field2], [field3] = approved
set [field4] = 1
if [field1], [field2], [field3] = denied
set [field4] = 2
else
...
user2094
0
votes
1
answer
2k
views
Can Search be performed on a calculated field in advanced search? (SP2007)
I have yet to find a definitive answer to this question. Right now this does not work for me in sharepoint 2007 and the only common characteristic I can find for the fields is that they are calculated ...
user2716
8
votes
4
answers
1k
views
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 ...
- 683
0
votes
2
answers
2k
views
How do I set up a calculated column to reference itself?
I need to set up a column that will keep a running total of values. I have a program that automatically sets values for the columns in SharePoint. The program will overwrite the previous value ...
- 347
2
votes
1
answer
804
views
How do you insert a column using the column editor in sharepoint designer 2010?
I would like to create a new calculated column in Sharepoint Designer 2010. So, IN SPD 2010 / Site columns, I click New, Calculated column, fill in the details and click OK. Up comes the the Column ...
- 140
1
vote
1
answer
187
views
Cell(Column) modified date question
I would like to know if there is a way to know when a cell has been modified and to store the date and time in a new cell.
Here is all the case:
I have a list, that need to be filled when an event ...
user1360
4
votes
4
answers
11k
views
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 ...
- 3,165
1
vote
1
answer
5k
views
Not able to add calculated field in Sharepoint 2010 list
I have created a calculated field called "Overdue" and provided the below formula as mentioned in the below link. But it is not accepting this formula. Please let me know what might be an issue.
...
- 319
1
vote
1
answer
2k
views
HTML Calculated Column Indicators
I'm trying to insert KPI indicators from the Out of the Box SharePoint images when my slippage column is at certain points, but the indicators don't seem to be showing, please can you help me with my ...
user1956
1
vote
1
answer
3k
views
HTML Calculated Column Formula
I'm trying to use a HTML calculated column so that I can display a RAG status bar for my tasks in SharePoint. I had it working until I added the IF containing % complete. Can you tell me where I'm ...
Rob
2
votes
2
answers
1k
views
HTML Calculated Column
I'm using the HTML calculated column that's outlined on the pathtosharepoint blog, but I'm wondering, is there any way to create a calculated column, that displays a button/check box or anything that ...
Rob
10
votes
5
answers
35k
views
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)....
2
votes
3
answers
1k
views
Calculated Field IF expression separators
I'm creating a list with some calculated fields from code that use IF expressions.
fieldCalc.Formula = "=IF([Field1]=0,[Field2],[Field3]&\" (\"&([Field4]/[Field5]*100)&\"%)\")";
...
- 410
2
votes
1
answer
2k
views
Why does my calculated column not pick up the correct ID
I'm trying to create a calculated column that uses the list item's ID field as part of the calculated string value. When I create a new list item, the calculated field seems to always use 0 as the ID ...
- 183
2
votes
1
answer
1k
views
Calculated Fields in Infopath
Does InfoPath allow me to use calculated fields based upon other field values on the form?
2
votes
1
answer
457
views
Easiest way to display computed field Or Is custom Field only option
I have a need to calculate working days until an item is due or working days past due. I also have to exclude holidays and the holidays may or may not apply to that item based on what project the ...
- 1,341
9
votes
6
answers
50k
views
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 ...
10
votes
2
answers
49k
views
Calculated value for Title field?
I would like to create a calculated value for the mandatory Title field:
<username, created by> - DD-MM-YYYY
That is I want the title to be filled in with the user name (the user that creates ...
- 743