Sussexguy44 wrote:Re Previous, the trigger formula does not work just now.
By trigger formula do you mean your formula in column AE or the trigger formula in column Q? Both look simple enough formulas and if anything could all be combined in the Q column or add $E$2="Not In Play" to your AE formula to tidy things up
- Code: Select all
=IF(AND($D$2<=TIMEVALUE("00:00:30"),AB5>=4,$E$2="Not In Play"),"1","0")
And
= IF(AE5=1,"BACK","")
Easiest way to try and check for errors is just to unlink your excel sheet from BA and put in figures manually to try and find where the error is occuring, like I mentioned earlier BA sends the time to D2 as text when the off time has been passed and is negative. So your trigger wouldn't play after 00:00:00. If you want to play in that time after the scheduled off time you can use the function ISTEXT($D$2) to check for negative times. So if you wanted your formula to check all the way up to the off time (when D2 may be negative and text) you could use
OR($D$2<=TIMEVALUE("00:00:30"),ISTEXT($D$2)) instead of $D$2<=TIMEVALUE("00:00:30")