how do I automatically assign a user list based on the selection from a mutli-choice text field?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

We have a text field called "Timeline Task" ... we want QB to auto-populate the "Assigned To" field based on the Timeline Task selected.

The trick is that the assigned to could be a single person or multiple people.

We have created users and formula user lists to help with the solution. We know we need to create a formula field. We tried to create a formula list user field but it doesn't seem to like that the formula includes a text field and a formula list user field.

Here's the formula we're working with:

If(Contains([Timeline Task]), "1B", ToUserList(ToUser([Medical Director]), ToUser([Account Director])))

Photo of Jennifer

Jennifer

  • 20 Points

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 340 Points 250 badge 2x thumb
The Contains function needs 2 parameters - so I think you need to put the closing parentheses ) after "1B" (from after [Timeline Task])

If( Contains([Timeline Task], "1B"), ToUserList(ToUser([Medical Director]), ToUser([Account Director]) ) )