Support Board
Date/Time: Sun, 16 Mar 2025 07:42:32 +0000
Post From: Auto flatten and cancel cell triggered when condition was not true
| [2022-08-04 21:25:32] |
| User35525 - Posts: 182 |
|
Just happened to me also. Thanks tomglib for the J57 suggestion. Not to hijack the thread, but here's my formula too if it helps (S3 triggers after 3:25pm. H23<H26 is true if daily Net P&L hits a daily loss limit. J21 is monitored since much depends on it): =AND($J$57=1, OR( $S$3=1, $H$23<$H$26, AND($J$84=1,$J$8=0, OR( $AD$3>2, AND(FRACTIME(IF($J$67=1,$J$41,A3))-FRACTIME($J$42) >= 10/86400, FRACTIME(IF($J$67=1,$J$41,A3))-FRACTIME($J$43) >= 10/86400) )), AND($J$84=0,$J$8<>0, FRACTIME(IF($J$67=1,$J$41,A3))-FRACTIME($J$42) >= 10/86400, FRACTIME(IF($J$67=1,$J$41,A3))-FRACTIME($J$43) >= 10/86400 ), $J$21<=0 )) *edit* I've seen my $AD$3 formula go #CREF on occasion for a brief period and will remove that bit from the OR Date Time Of Last Edit: 2022-08-04 21:44:04
|