Text Formula, Concatenate fields

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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]
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Dan

Dan

  • 1,176 Points 1k badge 2x thumb
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]
  )
)