Automation for missed daily log
I've got a sheet that is a daily log for the check of pool chemicals. We've set up some automation to trigger if the values drop or exceed certain thresholds. However would also like to trigger a notification if the frontline staff forget to record the daily readings.
I tried trigger when a date is reached (Daily) and if the Date field wasn't Today. It's triggering the alert every day so this is not working.
Help Article Resources
Check out the Formula Handbook template!