Calculated columns are the SharePoint equivalent of Excel formulae. 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.

learn more… | top users | synonyms

1
vote
1answer
2k 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 ...
2
votes
2answers
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 ...
4
votes
6answers
14k 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 ...
2
votes
3answers
966 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)&\"%)\")"; ...
1
vote
1answer
1k 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 ...
1
vote
1answer
806 views

Calculated Fields in Infopath

Does InfoPath allow me to use calculated fields based upon other field values on the form?
1
vote
1answer
399 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 ...
5
votes
6answers
19k 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 ...
5
votes
2answers
21k 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 ...