I set up a workflow to update List 2 when List 1 is edited. Now I want this update to trigger a workflow.
Apparently SharePoint does not treat an automatic (i.e. not user driven) update of List 2 as being an "edit" trigger for the workflow.
How else can I trigger the workflow?
I have been able to attach the workflow to List 1 and just have it pause 1 minute before checking the values of List 2 so List 2 has time to update. This works but will be impossible to implement since I actually have multiple lists updating List 2. I don't want to run the same workflow on every single one, especially since additional lists may be created in the future. Maintenance would be a nightmare.