Hello,
I have a request to create an automation rule that needs to set the Approver based on a specific value in field one and a specific value in field 2. For example, field 1 is a single select field with 3 different values to choose from (x,y,z). Field 2 is a single select field with 10 different values to choose from (1,2,3,4,5,6,7,8,9,10). Depending on the value selected in field 1 and 2, they would like a specific user to be assigned.
Example: If X and 1 are chosen, assign to user A, If X and 2 are chosen, assign to a different user.
Can this be done via 1-2 lookup tables or if there's a different way to do it please let me know. Thanks in advance!