I have an end of day checklist list set up in SP on-prem. I would like to schedule a site workflow to check the status of one of the columns each day (I know how to schedule the workflow). Basically, we are required to have two people sign off that the checklist has been completed. If the 2nd review has not been completed by 5:45pm I want a notification to go out to management. I have a site workflow setup to remind users to initiate the checklist for each day but I don't know how to build one to check the status of the "2nd Reviewer" column. If it's blank for that day I want the notification to go out. If not, just end the workflow. Can anyone help me out with this? I've been searching all over the nintex forums and haven't found the answer.
Thank you!