Triggering Automated Workflow with Cell Value (Date)

I set up a Notification automated workflow that was supposed to send a notification to a Program Developer (another cell in the sheet) if TODAY was [H-PDU (Next Update Date)], and then record today's date in [H-PDU (Notification Sent Date)].

First, the workflow didn't run at 10:00 am. I manually ran the workflow. Three should have received notifications (Program Codes 5002, 5005, and 5011). However, was updated for 5003, 5009, and 5010 as well, even though their dates in [H-PDU (Next Update Date)] were 03/19/25, 03/21/25, and 03/25/25, respectively. So I am assuming the Program Developers of those other three Program Codes received notifications (though I am not sure how you would know without asking them).

Why didn't the automated workflow run on its own at 10:00 am? And why did it not just run for those first three Program Codes? I don't have to be in the sheet for the workflow to run, right?

Related, I have another automated workflow that is supposed to update [H-PDU (Submission Status)] just for those rows that were supposed to be included in the first workflow (Program Codes 5002, 5005, and 5011), but the automated workflow didn't run either at 10:00 am, and when I ran it manually, it updated all of those other rows (Program Codes 5003, 5009, and 5010) as well to "Sent", when they should not have been updated.

Why didn't this automated workflow run on its own at 10:00 am? And why did it not just run for those first three Program Codes?

Find more posts tagged with

Accepted answers

All comments

kowal

hi @aschneiderheinze1025,

is this the first time it occured or it's happening all he time?

Did you make some tests by yourself and it's all the time occuring?

aschneiderheinze1025

@kowal Yes, I did a test and as I mentioned in my question, the workflow didn't run automatically. After I waited a few hours, I ran it manually, and it ran for most (not all) of the Program Codes in the sheet, even those that were not supposed to be updated (the date in the column didn't match TODAY). So, not sure why it didn't run automatically (and, yes, I've had workflows run automatically before) and not sure why it didn't only run for those that met the condition H-PDU (Next Update Date) had to be today and H-PDU (Trigger Notification) had to be checked. It looks like it ran for all rows H-PDU (Trigger Notification), which indicates the Program Code is up for an update, but it should only send out the notification to those Program Codes that have an update date of today.

kowal

hi @aschneiderheinze1025,

in that case I think the only option would be support center.

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.