Date/Time: Tue, 24 Apr 2018 03:13:23 +0000
Post From: Spreadsheet - Countdown Timer reference
|absorrel4 - Posts: 33|
I have a cell in my spreadsheet that references the Countdown timer column. The formula is a simple one... e.g., =if(aa3<5,1,0) My formula works fine and gives me a "1" when the countdown timer is < 5 seconds remaining....but my associated alert sound never goes off. I have tried all the different settings for the column within my spreadsheet study (i.e., "Alert Only Once Per Bar" yes/no..."Signal On Bar Close" yes/no...etc.). However, no alert sound. I think I remember that the if statement reference has to be in a different format to match the Countdown Timer??....but I tried all the different possible combinations within the statement with no success (i.e., I tried "hh:mm:ss" formats, etc.). How can I get this to work? I did this years ago and made it work, but I sure can not remember what I did....any help is appreciated. Thanks...