Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with calculated-column
Search options not deleted
user 1529
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.
2
votes
Create a calculated column to diplay midpoint between 2 dates
An alternative formula for @Laurie's Calculated column suggestion would be:
=AVERAGE([Start Date],[Due Date])
- 4,623
2
votes
Calculated Column - Last Name from Full Name
This will most likely be easiest with 2 calculated columns. Column 1 ("Part Name"):
=RIGHT([Full Name],LEN([Full Name])-FIND(" ",[Full Name]))
And Column 2 ("First Name"):
=IF(ISERR(FIND(" ",[Part …
- 4,623
3
votes
how to show HTML code in column?
We've recently released a free HTML Calculated Column; it acts just like a calculated column, but won't escape HTML:
Pentalogic's SharePoint HTML Calculated Column
Disclaimer: I work for Pentalogic; …
- 4,623
0
votes
Calculated Column colour coded result
I've written an article on the various ways of achieving this on our company blog. These are (in summary):
Client based
JavaScript: Put some JavaScript code into a Content Editor Web Part
Designer: …
- 4,623
2
votes
Check if more than 3 hours
Excuse my self-promotion, but:
We've developed a custom column that can do just that, which is currently in Public Beta: http://www.pentalogic.net/sharepoint-products/highlighter/beta-testers-guide
…
- 4,623
5
votes
How can I display a message on a list item when within X days of a date?
Partly inspired by this question, and partly because we developed a product that has this functionality, I've written a blog post (linked at the bottom) on how to achieve this.
The summary is:
Java …
- 4,623
1
vote
How to add line breaks in calculated columns without going into data view?
I've had a play around and I'm afraid I can't see a way to do this. The only two options I can think of are:
=CONCATENATE("A","
","B")
Which outputs A B because actual new lines are ignored by the …
- 4,623
3
votes
Accepted
URL in calculated column
We've recently released a free HTML Calculated Column; it acts just like a calculated column, but won't escape HTML:
Pentalogic's SharePoint HTML Calculated Column
To produce a clickable link, you'd …
- 4,623
1
vote
Accepted
How do we create dynamic url in Sharepoint 2010 Calculated field
I believe the formula you're looking for is this:
="<a href='"&[Link]&"'><DIV style='font-weight:bold; font-size:24px; color:"&[Tech]&";'>•</DIV></a>"
Where [Link] is the name of the column contain …
- 4,623
1
vote
Accepted
Using SharePoint version number in calculated column?
This is very similar to the problem with using =ID on item creation.
In short, the version number doesn't exist yet when the formula's result is being recalculated (during the update). It's added to …
- 4,623
0
votes
How to convert date field in single line of text using Calculated columns
It seems like you're mixing semicolon separators ; (in your main formula) and comma separators , (in the TEXT function).
It's also worth double-checking all your field names are correct: It may be a …
- 4,623
0
votes
How can we create and calculate a ([Due Date]- [Today])/7 column in SP 2010?
I wrote an article a while back about the different methods for creating a CountDown on a list view, which is essentially what you're looking for:
Warning: This also mentions our own product as a pos …
- 4,623
4
votes
Calculated Hyperlink Column - Lost ID-Field Value Upon Editing
Unfortunately [ID] isn't actually a supported field in calculated columns.
When a new item's values are being processed it doesn't yet have an ID, so the calculated field has nothing to work with. Si …
- 4,623
2
votes
Sharepoint - Calculated Column showing different colours based on list item age
I've written two articles on our company blog that address the two aspects of this problem. Each has a section on Javascript (linking to Christophe's blog, which you've mentioned you've seen), Designe …
- 4,623
3
votes
Accepted
Using an Additional Lookup Column Value in a Calculated Column
Unfortunately you're only able to use the following field types in a calculated field formula:
Yes/No
Calculated (as long as it isn't the current one)
Choice
Number/Currency
DateTime
Text
Lookups …
- 4,623