Support Board
Date/Time: Sat, 08 Feb 2025 09:20:23 +0000
Post From: ALERT Not Working
| [2020-06-29 16:08:56] |
| 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. |