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 78723
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
2
answers
99
views
Need help creating nested IF and LEFT formula in a calculated column
I have the following data in a text column called [Workcenter]
1 SOCS
CSS
SCXP
SCQA
SCOO
SCPR
I need a formula which will create the following results
CC
CC
SCX
SCQ
SCO
SCP
I'm trying …
- 1
0
votes
Accepted
Need help creating nested IF and LEFT formula in a calculated column
Thanks for the help Mike! This is what I have working:
=IF(OR([Workcenter]="1 SOCS",[Workcenter]="CSS"),"CC",LEFT([Workcenter],LEN([Workcenter])-1))
- 1