Support Board

Date/Time: Fri, 03 May 2024 15:58:22 +0000

Post From: Spreadsheet_alert ONLY once

[2021-10-12 17:11:55] Link To Thread - Link To Post [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