I am having trouble alerting based on upcoming date

Brian Ladwig

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.

Andrée Starå

Ok.

Try something like this.

Did it work?

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Brian,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Brian Ladwig

There really isn't any more detail to give.

I have a column named "Req Updagrade Date", when that date is today, I need to have the sheet e-mail all rows with that date to a user. It isn't complicated at all, I am just having a problem with the today portion. Using less than 24 hours away would work too.

Andrée Starå

Ok.

Try something like this.

Did it work?

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Brian Ladwig

I knew I was missing something simple. I tried going back through the certification classes I took and couldn't find it, Google wasn't helping me find it either. Thank you.

Andrée Starå

Happy to help!