Request cancellation
Hi, I create a smartsheet project for user to request an refund purposes process. In this smartsheet, first the user will fill out the form, and it will go to the HOD for approval and then to Finance for approval.
My question here is: when the process ongoing is being cancelled by a tick box, how do I make the whole respective request stop working, such that the approval email sent to the HOD will then expire and the whole workflow will stop?
Next is, when the request is complete, how do I make the cancellation checkbox impossible to click? I tried using the automation "status" template, but it does not work for me. Not sure how to apply formula with this if it is possible.
Answers
-
Hi @Happy
What I would do in this instance is make sure that the "cancelled" checkbox being un-checked is part of the Condition Blocks of any workflows of this process:
That way, even if the HOD approves the submission, the next workflow won't send out to Finance if the row has been cancelled in the meantime.
Then I would set up a second workflow that changes the Approval columns to be "Cancelled" when the checkbox is checked:
While this won't prevent someone from opening up an Approval Request if it's previously been sent out, it will update the field values when they go to Approve the request.
This means that you could add custom text to your original request to make it clear that if the value says "Cancelled" they can ignore this email. I've done a very rough draft here, but you can customize your text however you want:
The final thing you can do is set up a workflow to lock a row once the Finance approval is either Approved, Declined, or Cancelled:
Admins and the Owner of the sheet will still be able to update row content, but any of your other collaborators won't be able to make changes to the checkbox for that row (or any other cell in that row).
Here are some Help Articles that you may find useful:
Action blocks: Specify what kind of automation is triggered / Condition Blocks: Filter What Your Automated Workflows Send
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Thanks alot!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!