Automation Workflow Sequencing for E-mail Notifications
Hello, I've been rolling out some new sheets/processes to my colleagues and I've run into a little snag that I'm hoping to seek clarification from you awesome Community members.
Scenario 1: I have an input form that will automatically assign requests to a user and I also want to send an Alert to that Assigned To user. When I was doing testing to setup the sheet, the alert was set as a 'Send to Specific People' (me) and everything worked fine. Then I changed the alert to 'Contacts in a Cell' and choose the Assigned To user. Unfortunately, the e-mails are not getting to him. I'm guessing since the Assigned To is blank upon the request being created, that the two actions (Assign People and Alert the Contacts in a Cell) must live in two separate Automation Workflows. I have worked around it (I believe) by using the 'Send to Specific People' option and hardcoding the person's name into the workflow. I was hoping to avoid that, but it doesn't look like it'll be possible.
Scenario 2: I have a team that inputs details into a sheet and once they toggle a cell from No/Blank to Yes, then the row automatically assigns to a user and should e-mail the person in the field. Now, I'm suspecting that I'm running into the same issue here where an e-mail notification cannot go to the contact in the field because the field has not yet been populated by the same workflow. Again, I hardcoded the Specific Person into the automation.
I hope this makes sense and maybe it is a clear best practice, but I was hoping to avoid using hard coded name values and having to create multiple workflows to accomplish multi-step tasks.