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.
7
votes
Accepted
Calculated field Date formula
I believe the date/time format you are looking for is:
"dd mmm yyyy h:mm AM/PM"
This may be useful: TEXT function reference
- 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
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
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
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
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
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
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
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
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
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
calculated field - formula for ageing
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 (well, a CountUp):
Warning: This also mentions our ow …
- 4,623
0
votes
Display Calculated Field as link
If you want to avoid making XSL changes, you could try out my company's free HTML Calculated Column.
Here's my recent article on using it to create links that open in a new window:
Pentalogic: Openi …
- 4,623