Simple Workflow Not Triggering

Thank you for response. The status already changes to "Overdue" based on the formula's I've rolled out, the problem is triggering the workflow to send automated email when the status changes to "Overdue".

What you are suggesting is a different methodology to achieve the status change to "Overdue" so rather than a cell formula we use a workflow, but would this fix the underlying issue which is the trigger to automatically notify team members when the status changes to "overdue"?

Hi Gia, I've now tested this, and tweaked the workflow to take into account other scenariors.

This is great, I was not aware of this issue previously, and I think it's because all the other sheets that are in use get updated on a daily basis, as such the "Overdue" messages do get prompted, but this one will be different as I think the team will only interact with it monthly, so setting up the workflow to change the status to "Overdue" is perfect, this does come with two small drawbacks though:

1. The Status will no longer updates instantly based on changes to "Tracking" or "Due Date", but will only update once daily
2. I have to set up numerous different workflows for column Status to change to other things driven by Tracking column, haven't tested this yet, but hopefully it works.

It's strange because I did google the problem and couldn't find anything that gave me the "Workflow" solution, thank you for taking the time, much appreciated.

Kind regards,
Mark