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 47524
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.
9
votes
1
answer
20k
views
Calculated column increase date column by one day
I want to create acalculated column that takes a date field and sets the value to the date, increased by one day. How can this be done?
For ex:
If date field value: 20/10/2015
calculated result will …
- 393
1
vote
3
answers
9k
views
How to create traffic light indicator in sharePoint list? [duplicate]
I have 'Status' column having values 'Draft','Completed','In progress', 'Backlog'
Now I want to show corresponding Color code in 'traffic light' column.
Draft-->Grey
Completed-->Green
In progress-- …
- 393
1
vote
5
answers
15k
views
How to set Date column with default value as calculated value?
One date time column: Target date
Requirement:
Need to set default 'Target date',5 Days ahead of item creation date.
I have tried this:= but it is not working
=[Target date] = [Created] + 5
Kindl …
- 393
0
votes
2
answers
48
views
how to provide validation on to create SharePoint Date and time Column?
I want to create a SharePoint Date and time Column, so that the user is only allowed only to select a date 20 days ahead of today's date.
- 393