Discussions

Expand all | Collapse all

Text Formula, Concatenate fields

  • 1.  Text Formula, Concatenate fields

    Posted 04-20-2018 14:51
    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]


  • 2.  RE: Text Formula, Concatenate fields

    Posted 04-20-2018 15:14
    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]    )  )