Workflow Runs but appears not to recognise condition
I created a Sheet that continuously counts the time to a monthly meeting (4th Wed of the Month). The sheet has been checked and gets the correct date and interval. I use this date to calculate the interval / days to next meeting with a formula =[4th Wednesday of the Month]6 - TODAY() in a Column titled "Meeting Intervals"
The Workflow Runs and tells me it has run at the time set but the action is not taking place.
The Condition is what I think is not seen
Smartsheet Support told me I must put to "One of" which I doubted at the time and was borne out when the new day started and the Workflow ran. It previously failed on Equals and Contains.
The Activity is a simple Alert
What might help is: what really confuses me is that it appears to work when I change the condition and test it by changing the hour for it to run but that is all on the current day. It appears that its after a new day dawns that it breaks down. (I discovered this because I have 2 workflows to do similar but one sends a copy of the sheet row) This second workflow was received but the values had not been updated and showed yesterdays interval.
Thanks in hope that Help in the Community surpasses Smartsheet Support