I have created a request process for our sales team that incorporates automated workflows. As I built it out, I tested each component and every step functioned properly. The team started using it last week, and I have one workflow that will not run automatically. It will work if I use the Run Manually Option or if I manually change the data in the column/field. I can't figure out why after weeks of testing, this is happening. Here is the workflow:
This part is working fine; SS populated the MSA Signed Date based on a name match.
This is the notification to the AE, that we have the MSA and file, no further action on their part is needed
This is the step that gets stuck, the workflow is not changing the status unless I use the Run Manually option or change it myself. The status of Submitted triggers a separate workflow to the contract team to prepare the appropriate documents. (That works as well, once the status is Submitted)
I have another workflow if the MSA is NOT on file. It triggers an update request and once that information is provided, the Status of Request changes to submitted automatically and works fine.
I'm not sure why this workflow stops before the last step, when it worked while I was testing and it will run if manually triggered.
Any ideas will be helpful before I open a support ticket. Thanks in advance!