-
Automation creates duplicate row instead of updating it
Hi All, I was trying to set the following flow and it doesn't seem to be working Master Sheet - copy row to Project Plan (several conditions) = working fine Master Sheet edit row - edit a relevant copied row in Project plan =/ not working, creates a duplicate row with updated info --- is there any way around this? feeding…
-
Request an Approval from Email address in specific cell
Hi! I am needing some help. I am having a team member fill out a form, that form needs to be approved by several people. However it seems that the "Request an approval" needs to be a specific person (which wont work because each form will be different users", or Send to contacts in a cell, however it seems that the…
-
Conditional Approval & Approver Automation
Hi - I've been trying to come up with the best way to implement a process into Smartsheet and can't really come up with an ideal method. Hoping someone can give me an idea or point me in the right direction. We have a process where a user submits an intake item and then it goes to a general group for them to review/update…
-
IMS to to do RAIL sheet
My IMS has a list of Critical Items that I would like tracked in a RAIL sheet Task Name, Start, Finish and Assigned to, Currently I have been coping and pasting these values into my RAIL my RAIL sheet column are Task name, Assigned to, Start date, Due date, Notes, Priority I currently use my RAIL to track meeting minutes…
-
Is there a way to see who an automated notification was sent to?
I have a workflow set up that is based on using the symbols column. We have a ton of potential volunteers that have filled out a volunteer form and those that are marked as a 4 star or 5 star are then sent an automated email based on the email they entered in a contact column. The automated email instructs them on next…
-
Can I trigger an automation based on the completion of an update request?
I currently have a workflow in place which allows for both approval requests and update requests, but at two stages of the process, the approval request and update request fire off at the same time. The correct order would be for the approval request to process when the update request is complete. I have thought of adding…
-
Assistance Needed: Setting Up an Alert in Smartsheet for Unassigned Audits
I'm currently working on optimizing our workflow in Smartsheet and could use some guidance on setting up a specific alert mechanism. Our team manages incoming audit requests through Smartsheet, and we're looking to improve our response time for these requests. If an audit hasn't been assigned within an hour of its arrival,…
-
Formula Issue - Invalid Operation
=IF([Time Due]@row > [Day End]@row, [Day Start]@row + ([Time Due]@row - [Day End]@row), 0) Getting an "Invalid Operation" with the above and cannot seem to see it. I really think I have been looking at this Ticketing solution for too long.
-
How to keep a running tally?
Hello! I am trying to figure out how to create a formula to keep track of the Annual Funding Remaining for employees. As you can see with the #CIRCULAR REFERENCE and #BLOCKED I am not having any luck. Can someone assist me? TIA!
-
Are automations shared with other users when the sheet is shared?
Hello, I have set up a Goods In mastersheet which I will be the owner of. Within this I have set up 13/14 automations to notify different users when they receive a parcel. I have then shared this sheet with the Goods In Manager who will be inputting the data onto the sheet, will these automations also be shared with him or…
