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])))