"Wait for a condition" triggered by value in google sheets

Iโ€™m creating an app for my team to monitor us working alone. Staff members can indicate that they are entering an unsafe location/work. I would like it to notify my supervisor if they have not selected that the work is complete within 2h. I know that the appsheet wait for a condition doesnโ€™t currently support any sort of timer, so I created a column in google sheets (Unsafe Duration) that calculates the time since the form was created {HH:MM}. I then set it to send a text when [Unsafe Duration]=02:00. However, it sends the text immediately. Any ideas what Iโ€™m doing wrong?

0 1 107
1 REPLY 1

Top Labels in this Space