Home >> Support Board

Support Board

Date/Time: Sat, 20 Apr 2024 15:36:39 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet_alert ONLY once

View Count: 335

[2021-10-12 17:11:55] #1 [Go To First Post]
User291209 - Posts: 2
Hi Sierra, I would like to ask you if you can help me in the following issue. I created an alert with three conditions (all three gives 1 if condition is met). In order to notify me only in case all 3 conditions are met, I coded the following in Q3 cell: =(L3+N3+P3)=3. That's working fine. What I would like to achieve is that I want to be notified ONLY FIRST TIME if all conditions are met. In most cases I receive alerts several time after first time, which means that my phone is beeping a lot, unnecessarily. Hope you can provide me some useful advice how to set it up. Many thanks in advance. Regards, Tamas

[2021-10-12 20:10:31] #2 [Go To First Post]
Sawtooth - Posts: 3976
Try this in column R: =AND(Q4=0,Q3) This moves the alert to column R, since it finds only the first time Q goes TRUE.

To post a message in this thread, you need to log in with your Sierra Chart account: