You reference fields/columns by their display names in square brackets, eg: [Deliverable Status]. You concatenate these with the “CONCATENATE” keyword. You need to make sure that there is absolutely no blank space in your formula.You also have IF statements that work like so: IF(condition,value_if_condition_is_true,value_if_condition_is_false).
The following works in a field called “Deliverable Type Display”:
=IF([Deliverable Type]=”Deliverable”,”[DL] -“, IF([Deliverable Type]=”Milestone”,”[ML] -“, IF([Deliverable Type]=”Ad-Hoc Task”,”[AT] -“, ” “)))
The following works for a field called “Deliverable Display”:
=CONCATENATE(IF([Deliverable Type]=”Deliverable”,”[DL] – “,IF([Deliverable Type]=”Milestone”,”[ML] – “,IF([Deliverable Type]=”Ad-Hoc Task”,”[AT] – “,”[No Type]”))),[Deliverable],” – “,[Deliverable Status],” – “,DAY([Due]),”/”,MONTH([Due]),”/”,YEAR([Due]))
YOU HAVE TO REMOVE ALL THE BLANKS FROM THE FORMULA TO WORK. OTHERWISE, THE RESULT ALWAYS IS “2”.
For example, this:
=CONCATENATE(IF([Deliverable Type]=”Deliverable”,”[DL] – “,IF([Deliverable Type]=”Milestone”,”[ML] – “,IF([Deliverable Type]=”Ad-Hoc Task”,”[AT] – “,”[No Type]”))),[Deliverable],” – “,[Deliverable Status],” – “,DAY([Due]),”/”,MONTH([Due]),”/”,YEAR([Due]))
works, but this:
=CONCATENATE(IF([Deliverable Type]=”Deliverable”,”[DL] – “,IF([Deliverable Type]=”Milestone”,”[ML] – “,IF([Deliverable Type]=”Ad-Hoc Task”,”[AT] – “,”[No Type]”))), [Deliverable],” – “,[Deliverable Status],” – “,DAY([Due]),”/”,MONTH([Due]),”/”,YEAR([Due]))
does not work because there is a blank space preceding the [Deliverable]. (it’s in the Ad-Hoc Task comparison, after the comma: , [Deliverable],)
