Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 23:18:17 +0000

How to Post a Message for Support

Post From: ALERT Not Working

[2020-06-29 20:09:27]
[Go To First Post]
User19100 - Posts: 9
@tomgilb

I copy/pasted the code and, again, received a Syntax Error. Here is what I attempted.

=IF(ROW()=3,AND(ID15.SG1[-1]>ID15.SG1,ID15.SG2[-1]>ID15.SG2,ID13.SG1[-1]>ID13.SG1,ID14.SG1[-1]>ID14.SG1,O<C,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)>=55/1440,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)<60/1440),0)

On the previous fix, it appears that an "@" was used to replace [-1] and the like.