-
Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
-
Including Images in a Workflow Automation
Hello Everyone! I am creating an automation and am aware that an image cannot be included in the body of an automation email. However, I opted to have the image attached to the workflow email by including certain cells. The issue I'm running into is that when the image is attached to the email I am getting the following…
-
Approval Workflow to Multiple Persons
I have an approval workflow that goes to multiple people. At present, it seems if any one of them approves a View Request, the request is Approved. Is there an easy way to require all those who receive the approval request approve it before marking the request "Approved"? I know I can breakout the approval persons into…
-
Automation - While copying/Moving Source Sheet to Target Sheet, how to update columns in Target shee
I have following questions related to workflow automation Is it possible, based on certain conditions in Sheet-A copy Sheet-A to Sheet-B and manipulate another column in Sheet-B (This Column is not in Sheet-A) through a function? Based on certain conditions in Sheet-A, will it be possible to delete a row in Sheet-B?
-
Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.
-
Determine follow-up date that will trigger Workflow
I want a date to populate a field that will trigger a follow-up workflow. My criteria is: If the certification Complete is GREEN, this date can remain blank, as no follow-up will be sent. If the certification Complete is YELLOW or RED, the Manager has either partially completed (yellow) or not completed at all (red). The…
-
Multiple Automated Workflows Triggering for same item
Hi! I have helped design a Smartsheet that we are using to track requests. There are three scenarios that we need to capture, and each scenario has a slightly different workflow because certain approvals are or are not required along the way. I am running into an issue when the request is declined, all of my workflows are…
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
-
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
-
To be able to modify/update certain column setting using Approval Workflow
In the Approval Request workflow, we need to be able to modify some of the columns in the approval path instead of adding another action to follow. As our approver "approves" in the Approval workflow, our approver needs to add additional information in the column. If we use update request, this creates 2nd…