-
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…
-
SLA Calculation Strategy
Background: There are four (4) SLA priorities in the Ticketing intake: Critical = 4 hours: High = 8 Hours: Medium = 24 hours: Low = 48 Hours Using the Created Date (including both Date and Time) I need to create the Planned SLA Finish for each ticket. SLA Plan is expressed in Hours This needs to also be a Date and Time…
-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Submitting names to a Smartsheet column
Hello everyone. I need some helps with name additions. At my company we are going through a major hiring phase and my reporting lead and myself are getting asked repeatedly if we can add names to a column in one of our Smartsheets. Is there a way I can create a sign up sheet per say where only the supervisors can add the…