Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 02:57:28 +0000

How to Post a Message for Support

Post From: ALERT Not Working

[2020-06-15 18:46:10]
[Go To First Post]
User19100 - Posts: 9
Hello, I've created the following formula, which works with "Color Background based on ALERT Condition" but I want it to trigger 5 minutes before the top of the hour. When I add the "BARTIME" formula, it doesn't work. I don't get the color background nor does it trigger an ALERT.

=AND(ID16.SG1[-1]>ID17.SG3[-1],ID16.SG1<ID17.SG3,ID15.SG1[-1]>ID15.SG1,ID15.SG2[-1]>ID15.SG2,ID13.SG1[-1]>ID13.SG1,ID14.SG1[-1]>ID14.SG1,BARTIME>=TIME(5,55,0),BARTIME<=TIME(6,0,0))

Any help would be greatly appreciated.