Duplicate Notifications and to Everyone in the Workflow
Issue:The notifications for the CD level and RVP level are duplicating and sending to everyone in the workflow. Something is wrong with the workflows I created.
Sheet Design
Each row has someone assigned {Response Assigned to
} to add the response to the {Center Responses
} column. The person in the {Response Approved By
} column reviews the response and eventually approves them. The status of that review is captured in the {WF Status
} column. All of this happens in the orange columns.
Next, the CD reviews the approved {Center Responses
}. If needed, they can request revisions from the people in the {Response Assigned to
} and {Response Approved By
}列。评论我的状态s captured in the {CD Status
} column. This happens in the orange columns.
Last, the RVP performs the same review as the CD but is the final approver. If needed, they can request revisions from the people in the {Response Assigned to
} and {Response Approved By
}列。This happens in the purple columns.
Three workflows:
(1) Director level: First in the approval process.
(2) CD level:Second in the approval process.
(3) RVP level:Third and last in the approval process.
Link to test sheet:https://app.smartsheet.com/sheets/fxw7mv4gxQ4jRhH8Frv76FJGVmMcP9RWHmh3rq81
Answers
-
Andrée Starå ✭✭✭✭✭✭
I hope you're well and safe!
I've requested access. I'll take a look.
Be safe and have a fantastic weekend!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Andrée Starå ✭✭✭✭✭✭
Which of the Workflow is being duplicated more specifically?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Amy Arnold ✭✭✭✭
Hi@Andrée Starå. two notifications are triggering simultaneously in the CD and RVP workflows.
Both workflows are set up similarly so included the CD workflow below. I believe two notifications are triggering simultaneously at the "Request an Update" and the "Request an Approval" checkpoints.
There's probably a better way to set this up too
I appreciate your help, thank you.
-
Emily Eberle-Levine Employee
I've requested access to the sheet as well. By any chance are you re-using the same approval column/values across separate workflows? When you build the approval automation, Smartsheet automatically creates a unique column to store the approval decision. If you change that column to something else, and the approval columns and values are re-used across workflows, duplicate alerts may go out. To prevent this, use different approval values or add conditions after each approved or declined request to better clarify. Here's more information about approval workflows:https://help.smartsheet.com/learning-track/smartsheet-intermediate/approval-requests
Cheers,
Emily
Sr. Product Manager, Automated Workflows
-
Harbani ✭✭
I'm facing a similar issue can someone assist?@Andrée Starå.
-
RebSchr ✭✭✭✭
@Harbani——这是我不得不利用或解决方案der to prevent multiple notifications. It required me to put a condition 'after' the approval / decline. I did submit this as a potential enhancement to workflows. In my opinion, the first condition should satisfy the rest of the workflow.
Hope this helps!
Rebekah
Categories
Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106937,"type":"question","name":"Column shifting","excerpt":"Hi There, Currently, I have set up dynamic drop down in target sheet and the rule is the column index can not change (i.e. stay index 32) However, the column is shifting (i.e. from 32 to 57) but user claims they didn't move or change the column index. Is there any way we can figure out why this happening or any where we…","snippet":"Hi There, Currently, I have set up dynamic drop down in target sheet and the rule is the column index can not change (i.e. stay index 32) However, the column is shifting (i.e.…","categoryID":321,"dateInserted":"2023-06-27T07:31:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T06:57:45+00:00","insertUserID":161133,"insertUser":{"userID":161133,"name":"Man Chui","url":"https:\/\/community.smartsheet.com\/profile\/Man%20Chui","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T07:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161133,"lastUser":{"userID":161133,"name":"Man Chui","url":"https:\/\/community.smartsheet.com\/profile\/Man%20Chui","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T07:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3375787738,"url":"https:\/\/community.smartsheet.com\/discussion\/106937\/column-shifting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106937\/column-shifting","format":"Rich","lastPost":{"discussionID":106937,"commentID":382749,"name":"Re: Column shifting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382749#Comment_382749","dateInserted":"2023-06-28T06:57:45+00:00","insertUserID":161133,"insertUser":{"userID":161133,"name":"Man Chui","url":"https:\/\/community.smartsheet.com\/profile\/Man%20Chui","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T07:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T06:56:02+00:00","dateAnswered":"2023-06-27T12:25:56+00:00","acceptedAnswers":[{"commentID":382510,"body":"
This should be present from the activity log.<\/p>
<\/p>
<\/p>