Skip to main content
Question

Text Formula, Concatenate fields

  • April 20, 2018
  • 0 replies
  • 92 views
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]
      This topic has been closed for replies.

      • DanLadner1
      • Quickbase Alumni
      • April 20, 2018
      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]    )  )
      Terms & ConditionsAccessibility statement