I am having trouble alerting based on upcoming date


I have looked and not found an answer that has worked yet. I have a sheet we are using to schedule Windows 10 upgrades. I have created a form that users fill out to request an upgrade date.

What I need to do is send an e-mail to the person doing the upgrades that tells them who is scheduled to be upgraded that day. The sheet is shared to the person doing the upgrades. I tried a few different things and none of them worked. I won't bother posting what I tried. I am thinking there is something simple I am missing.

Can I just use "is equal to" Today() in the value for the field I am alerting on?

Any help y'all have is appreciated. I am fairly new to SS.

Best Answer