Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
7 years ago

Text Formula, Concatenate fields

I am having a terrible time creating a field to concatenate several fields based on conditions. First, should I use a text formula or rich text? Neither seem to work. I have a combination of multiple choice conditions and checkboxes.



For example,

 If a task type is "Project" and Risk is checked, I'd like the task name to be:

"Risk: Project  " & [field name] & [field name]



 If a task type is "Project" and Issue is checked, I'd like the task name to be:

"Issue: Project  " & [field name] & [field name]
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    7 years ago
    Something like this (this could be formatted differently depending on whether the "field name" values are the same whether it's a Risk or Issue):
    If(  [Task Type]="Project",    If(    [Risk],    "Risk: Project  " & [field name] & " " & [field name],    [Issue],    "Issue: Project  " & [field name] & " " & [field name]    )  )