Forum Discussion

QuickbaseKinnec's avatar
QuickbaseKinnec
Qrew Member
2 years ago

User List field based on multi-select values

Discussions Hi QB Community! I'm looking for some help with a formula. I'm building an employee onboarding workflow in Quickbase. There are multiple programs that will use the app and ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

I think this is a case where you do need more IF's.

ToUserList(

If(Contains([Send Notification To], "HR Coordinator"), [Program HR Coordinator]),
IF(Contains([Send Notification To], "IT"), [Program IT]),
IF(Contains([Send Notification To], "Program Director"), [Program Director]),
IF(Contains([Send Notification To], "Office Coordinator"), [Program Office Coordinator]),
IF(Contains([Send Notification To], "Operations Manager"), [Program Operations Manager]),
IF(Contains([Send Notification To], "Program Coordinator"), [Program Coordinator]),
IF(Contains([Send Notification To], "Project Manager"), [Program Project Manager]),
IF(Contains([Send Notification To], "Jetpack Group"), [Program Jetpack Group]),
IF(Contains([Send Notification To], "Program Benefits Coordinator"), [Program Benefits Coordinator]),
IF(Contains([Send Notification To], "Program Executive Director"), [Program Executive Director]))



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------