UPPER
UPPER(text)
Gives the text in capitals, for showing codes or labels the same way on every row. You don't need it to compare text: = and CONTAINS already ignore case.
Arguments
| Argument | What to give it |
|---|---|
| text | Text, like [Phase] or [Name]. A choice field such as [Status] works too. Blank gives blank. |
Examples
Formula=UPPER([Phase])
The task's phase in capitals.
Formula=UPPER(LEFT([Discipline], 3)) & "-" & [Task code]
A label such as a three-letter discipline prefix in capitals, then the task code.
Formula on resources=UPPER([Name])
On a resource: its name in capitals.
Reach for something else when
Common questions
Do I need UPPER to compare two pieces of text?
No. Text equality ignores case, as in Excel: [Phase] = "civil" matches Civil. See text.