I have a few automation to notify someone when certain condition met, but it works during our testing phrase, then I deactivate them for almost a week and turned them back on, but now it doesn't work!
I event duplicate it as a new workflow and delate the original automation I created, but they still didn't receive them!
Please see some of the screen shots below as a reference
@Waranya I have run into this issue when I have conditions in there that are the same as the trigger. So I removed the conditions. I also made sure to leave the trigger to added or changed.
Are the contacts in a cell smartsheet users?
Thank you! I will try that to remove the condition to not duplicate with the trigger and yes it is to notify people who are listed in the cells.
But some other automation that doesn't have duplicate conditions as trigger also doesn't work though
Hi Waranya
I am still learning myself, but from what I can see, there are a couple things you should look at:
In your “Manager got notification of new referral - Routine Priority Level (New)” automation, I don’t believe you need the Condition since you already have that change identified as the trigger. But I don’t believe that is why it wouldn’t run. You don’t show in your example what cell you selected for the Send to contacts in a cell option. Do you have more than one cell that is listed as a contacts cell? Did you select which cell should have the contact in it that you want to alert? Like Referrer’s Email Address or Staff Assigned? (I can’t see what, if anything, you selected).
In your second example “Send Status Update with Staff Name Assigned to Referrer” you selected 2 different referral statuses. Did you enable that column to allow 2 different values at the same time? If not, you will need to have it like this:
Trigger: When rows are changed
When Referral Status changes to Staff Assigned
+
When Referral changes to Referral Assigned
In that example the + essentially equates to “or”. So when Referral Status changes to Staff Assigned OR Referral Assigned. Otherwise the way you have it written it would require both status to be selected or it wouldn’t trigger the alert.
In your third automation, “Sent Status Update to Referrer” the issue looks like the same from above, that it would only trigger the alert if ALL those statuses were selected. Otherwise, if you want it to just send in any one of those were selected you would need to enter it as a separate trigger, so when it changes to Referral Reviewed + (or) Outreach Initiated + (or), etc….
In your fourth automation, “Notification for Urgent request to RC, Manager, and CC to referral (New)” it looks like a similar scenario as the top one. The condition is the same as the trigger, which isn’t necessary. But I can’t see if you selected a column for the ‘send contacts in a cell”. If no field is selected in the formula, it wouldn’t trigger. Likewise, if you select the correct field/column for the ‘contacts in cell’, if there is a blank in that field it also wouldn’t alert anyone.
For you last automation, ‘Notify Corresponding staff member based on client language - Vietnamese (New)” it looks like it should alert whomever is listed in the Staff Assigned column for that new row. (As long as there was somebody in that column).
The only other thing I can think of is for those Contact columns, you need to make sure you actually ADD the contact. So for this contact field in my Smartsheet “Assigned to” :
You need to make sure you don’t just type the name and hit enter, but instead fill out the name/email address by selecting the down arrow, then add new at the bottom. Here you can add the name/email address.
Once you add a contact to a sheet they are part of the contact list for that sheet, so you don’t need to add them to every row, just select their name from the drop down at that point. Even if you have 2 different contact columns (Staff Assigned, Referrer), you will still have one contact list for the sheet. Also, just because you share a sheet or workspace to an individual, that doesn’t automatically make them a contact on the sheet, from my experience.
I hope some of this helps….
Thank you for your input and taking time to help me. Much appreciated. I did try those and the issues are it works before I deactivate it and activate the automation back in again. I think I will just have to create new automation and see, if it still didn't work may have to come back here and ask for help again
After you re-enabled the automations, did you have any new data to trigger those automations?
some of them yes, but I already made sure all the automations updated and included in those automations
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
