Scenario: we are using smartsheets as a single-source tool for job/position requests.
Each request submitted creates a row and all information pertaining to that request is held within that row.
We need to get approvals from Department Heads for each request submitted.
However, we don't necessarily want to create a contact list - but instead have the Department Head Email address entered in as a separate entry on the smartsheet request form.
Can we create an approval workflow to send the notification to the Department Head Email address listed in that particular cell?
We have around 25 departments and creating a Contact List may be hard to keep up with due to staff/personnel and email address changes.
Additionally, none of these Department Heads will be set up as smartsheet users.
THANK YOU!