How to have automation populate specific contact within column based on state selected in row?
Scenario: You need alerts and approval requests to go to "contacts in a cell" based on department and state. Is there any way to accomplish this aside from creating a separate contact column for every single state which then has to also be programmed into the automations?
(i.e. Request 1 affects all departments for GA, NC, and SC - I need notifications to go to contacts in "manager/approver" column, but only GA, NC, and SC managers; not all states' managers. It gets more complicated if it only affects marketing and sales departments...now I need the notification or approval to only go to those department managers for those states.) Creating a different contact column for every state and department with different contacts loaded into each AND setting the separate automation logic seemingly would take until 2025 ;)