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 64754
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.
0
votes
The formula contains a syntax error or is not supported
I read other posts and I managed to solve the problem. By using today() the formula would be:
=IF(OR(Status="Overdue",Status="Open"),(TODAY()-[Date Raised]),"")
It worked perfectly throughout the en …
- 1
0
votes
2
answers
2k
views
The formula contains a syntax error or is not supported
I'm trying to add a column to a table I created in SharePoint. I want the column to do the following:
Given the status of an action e.i. due or over due, calculate the number of days that the action …
- 1