I have a SharePoint list with a 'due date' field and a 'submitted date' field in it. We use this to track report submissions to various customers. I would like to set up a site workflow that sends a reminder email if the 'due date' equals today and the 'submitted date' field is still blank.
My current attempt at this workflow queries the list to see what items have a blank value in the 'date submitted' field. Then a Run if function to see if the date due is equal to today. If it meets that criteria send an email notification.
It seems like this should be simple but it isn't working. I saw a few similar questions that never seemed to get resolved. Any ideas or suggestions? Thanks in advance!!!