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.
1
vote
5answers
4k 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 ...
6
votes
4answers
749 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 ...
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 ...
2
votes
1answer
513 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 ...
2
votes
2answers
681 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
1answer
719 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
3k 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 ...
1
vote
0answers
266 views
CAML Contains on a lookup field of a calculated column
I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column.
It basically does not work, the Equal works though.
here is the query, nothing ...
0
votes
0answers
64 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
67 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 ...
0
votes
1answer
756 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 ...
