Best practice for sending notificatons from 1 smartsheet based on users in a 2nd smartsheet
I have a master smartsheet with client name, a date and the clients product lines, on a row. The product line column is a multiple select, restricted to a specific list of values.
I have second smartsheet by department and users within the department. I am thinking of adding the product lines which the department is responsible for.
I would like to have a workflow on the master smartsheet which can look at the second smartsheet to determine who to send the row data to when a specific date is met.
Is this the correct way to set this up or is there a better way to manage this?