Hi Everyone, New to Smartsheet so sorry for the rudimentary question. I'm having trouble getting automation to do what I want it to. I have a project sheet with multiple tasks with various due dates. I'm trying to send reminders prior to the due date. I do the following:
Trigger: Run Once: On: Date Field: Due Date: 9:00AM
Condition(1): Where: Due Date is today
Condition(2): AND Where Complete is not checked.
The sheet sends reminders out for all tasks rather than just the one I intend. What am I doing wrong?