I have to create an automation that runs everyday at and checks if the date in the calendar is true with the date in the column “start datate” and send an email to the person “responsable of the task” with object “name of the priject” and text “start with - name of the task”.
Somebody can help me?
I’m playing around with this. I haven’t solved your challenge, however, I think there’s something here.
I’m trying to trigger a row change based on time. Once this happens, you can trigger an automation:
I’m using an if statement to check when now() is greater than your start date. Running the automation works, just can’t get my time formula to “modify” a row.