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.

Find more posts tagged with

Accepted answers

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!

All comments

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?

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.