I hope someone will be able to point me in the right direction.
I have been trying to figure out the easiest way to use a row change automation based on a date and time column.
WHEN a date and time in the Project end date column is equal to now() and
(IF) the checkbox is set to true()
THEN a notification is sent.
The checkbox is set to true at the right time with a formula. However, the automation is not picking up the row change. I also tried using a select status instead of checkbox but the result is the same. Is this because the automation is based on a formula?
I found a workaround posted by Shishir from March 2019 that utilizes a button being pushed at a set time each day, which probably will work fine, but I would prefer to avoid this step if possible.
In Airtable I could set up an automation without the use of a checkbox to signify a row change. Is there a way that my scenario can work the way I present it without using a button automation?