Support Board

Date/Time: Sat, 20 Apr 2024 05:03:51 +0000

Post From: ALERT Not Working

[2020-06-29 16:08:56] Link To Thread - Link To Post [Go To First Post]
User19100 - Posts: 9
Previously, you assisted me with creating an alert that would trigger 5 minutes before the top of the hour. It works great, by the way. Thank you. I'm very new to this type of thing all together but attempted to use snippets from the code you helped me with to create another alert with different parameters. I was unable to replicate the outcome. Here is the code with which you previously assisted. =IF(ROW()=3,AND(ID16.SG1@4<ID17.SG3@4,ID16.SG1@3>ID17.SG3@3,ID15.SG1@4<ID15.SG1@3,ID15.SG2@4<ID15.SG2@3,ID13.SG1@4<ID13.SG1@3,ID14.SG1@4<ID14.SG1@3,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)>=55/1440,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)<60/1440),0) The new code, with which I am working is the following. I would like to have it also alert 5 minutes before the top of the hour. =AND(ID15.SG1[-1]>ID15.SG1, ID15.SG2[-1]>ID15.SG2, ID13.SG1[-1]>ID13.SG1, ID14.SG1[-1]>ID14.SG1,O<C) Any assistance would be greatly appreciated.