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

3
votes
5answers
7k 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 ...
4
votes
1answer
1k views

Calculated Hyperlink Column - Lost ID-Field Value Upon Editing

I created a calculated column with the following formula: ="<a href='../X_C03 Staff Members/DispForm.aspx?ID="&ID&"'>View</a>" and included this into a view. The column works ...
6
votes
4answers
943 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 ...
6
votes
2answers
18k views

Using calculated field to retrieve substring of another field

Suppose I have a field that contain the following data: ========================== | Email Address | ========================== | Jack@wonderland.com | | Peter@nobodyland.com | | ...
9
votes
2answers
1k 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 ...
4
votes
3answers
4k views

How to set the Default value of a Date/Time column to next Friday?

I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right ...
3
votes
1answer
5k views

Calculated Column with Nested IF statments

Here is my current formula that works. ="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Project Close A]="",IF(Program="CAPITAL",IF([Project Close P]>=[Current ...
1
vote
2answers
2k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists. Can any one please guide me on this topic> ...
2
votes
2answers
1k views

Using SharePoint version number in calculated column?

I'm trying to get the value of column "Version" in a calculated column. I'm not sure if it's a bug with SharePoint 2007 but every time a document is updated, the version number shown in the calculated ...
1
vote
3answers
729 views

Dynamically hide column list item if the field is empty

I have a series of fields that I would like NOT to appear in my list dispForm.aspx. So when a user creates a new list item if these fields are unpopulated the do not appear DispForm.aspx but I still ...
1
vote
1answer
136 views

Calculation field randomly forgets ID

I have a calculation column that I use to display some HTML code that provides a hyperlink in a List view. The user clicks on the hyperlink to jump to another page which will generate a report based ...
1
vote
1answer
904 views

Calculated Column left align header

In my list, I want a column to have a custom hyperlink. I create a Calculated column that has the following formula. ="<a ...
1
vote
1answer
2k views

How to match current user to a username column with Calculated Columns?

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 ...
1
vote
1answer
2k views

Infopath: Copy calculated value to list field

I'm using InfoPath and SP 2010. I'm using calculated fields which works well, but I wonder if there is a way to copy calculated field value to standard list field when form is submitted ?
1
vote
2answers
6k views

How can we create and calculate a ([Due Date]- [Today])/7 column in SP 2010?

How can we calculate ([Due Date]- [Today])/7 column that updates daily as value of Today changes and lets us calculate weeks left for due date ? Could create ([Due Date]- Today() )/7 and it worked ...
0
votes
2answers
258 views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
0
votes
1answer
618 views

Designer Workflow: “Find Interval Between Dates” action not working

I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
0
votes
3answers
132 views

Modifying a calculated column gives different errors

I have site column with the following formula: [AmountLeftToPay]/([AmountAssigned]-[AmountReleased]) The problem is the division by zero, sometimes it shows on list items #DIV/0! So I wanted to do ...