Approval workflow
Hello!
I need to create an approval workflow with these conditions. Please also find below the problems I'm encountering:
- 当一行添加、改变或删除。(问题#1: I don't manage to set this up for rows that have been deleted.)
- Whenanyaction above is performedonly by specific email addresses. (Problem #2: I've not been able to set up the workflow so that it allows me to add those email addresses directly to it.)
Thank you in advance for your help,
Berta
Answers
-
Andrée Starå ✭✭✭✭✭✭Hi@Berta
I hope you're well and safe!
Can you describe your process in more detailand maybe share the sheet(s)/copies of the sheet(s) or somescreenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅我的帖子(s)他吗lp or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. 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.
-
Genevieve P. Employee AdminHi@Berta
You won't be able to set up an Approval workflow when a row is deleted because it will no longer exist in the sheet to be approved, does that make sense? There's an Alert workflow we can build to notify you if something was removed. You can thencheck the Activity Logfor more details (if your plan has access to it).
In regards to specifying if the change has happened by one person, you will want to set up aModified Bysystem created column in your sheet (see:Use a System Column to Automatically Add Information to a Row).
Then you can use this in a Condition block! (See:Condition Blocks: Filter What Your Automated Workflows Send)
Let me know if you still want help building this out. If so, I agree with@Andrée Staråthat it would be useful to see screen captures, but please block out sensitive data.
Cheers,
Genevieve
-
Berta ✭Hello@Andrée Starå, hello@Genevieve P.,
Thank you very much for your comments above. They helped me set up what I needed.
Regards,
Berta
-
Andrée Starå ✭✭✭✭✭✭
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.
-
Berta ✭
Hello again@Genevieve Evansand@Andrée Starå,
I've created a weekly alert for rows that are added or changed by certain people (thanks for your advice!), but I cannot set the day of the week and the time to receive these alerts. How can I customize this?
I'd also need your help to create an alert workflow for removed rows, as you suggested above, please.
Last but not least, I'd like to move rows whose status is changed to "Closed" to a subsection in the same sheet. However, the only option I've found allows me to move it to a different sheet.
Thank you very much in advance,
Berta
-
Genevieve P. Employee Admin
Hi@Berta
1) Weekly Workflow:
Weekly workflows will run between the first Friday at12:00 AMand11:59 PMthe following Thursday, and messages will be delivered between12:00 AMand4:00 AM在第二个星期五。
See:Trigger Frequent, Change-Based Automations in Batches
The alternate way to set this up would be to have thetriggerset as a date, with theconditionbe the change that happened. See:Create a Time-Based Automated Workflow
2) Deleted Row Alert
Go to Automation > Manage Workflows > click the dropdown to create a workflow >Basic Workflow
at the bottom:
Then you can select "Alert someone when a row is deleted":
3) Hierarchy and Workflows
There currently isn't a way to automatically move a row to be under a specific Parent row. Please submit your suggestion and feedback to our Product teamthrough this form, here!
Cheers,
Genevieve
-
Berta ✭
Thank you very much,@Genevieve P.This is very helpful. I'll fill in the form for the third point.
I've set up the basic workflow for the deleted rows, but the email I receive doesn't specify which rows were deleted:
Is there any way the message body can be customized?
Regards,
Berta
-
Genevieve P. Employee Admin
Hi@Berta
No, since the row has been deleted there is no information about the row that the alert can specify. You will need to access the sheet's Activity Log (if your plan has access to this) in order to see the history and content of that deleted row. See:Track the History of Changes with Activity Log
-
Berta ✭
I understand. Thank you very much,@Genevieve P.
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/82988/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/82988/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p>
<\/p>
Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4892,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
