-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Is it possible to edit an automation without removing all the subsequent actions?
Hello, I am trying to change one part of my automation for request an approval to requesting an update. Unfortunately, this part of the automation is towards the beginning and it seems the only way to edit the automation would be to erase and redo everything. Is there a way to make an edit with out clearing the rest of the…
-
Consolidation of Attachments from Multiple Sheet?
I have multiple sheet where data is coming through forms and each form has attachment option as well. My goal is to consolidate information into Master Sheet. I have successfully consolidated the information into Master Sheet but having problem with the consolidation of attachment. HOW CAN I CONSOLIDATE ALL ATTACHMENTS…
-
How do I customize a request ID based on specific form selections?
iaI know how to create a request ID on the column grid but I wonder if I am able to customize based off of specific selections on form submissions. For example, Jane Doe selected content management (CM) in her form submission so the request ID would reflect that (Request ID: CM_0001), where John Smith selected quality…
-
Tracking Contact Approvals in Hierarchy Level using Helper Column
Hello Smartsheet Community, I'm creating a Smartsheet Automation to send out approvals (starting with level 1). I'm making this helper column (L1 - Status of Approvals) to determine if all the listed contacts have given approval in the contact approval columns before moving onto level 2. As you can see in the screenshot…
-
Workflow to PDF
Hi, I am trying to figure out how to take data and pictures submitted via a smartsheet form and have it automate into a formated PDF. It seemed like there was a workflow that would allow this, but I am struggling on making it happen.
-
Automated email not showing updated smartsheet
So i have an automation set up for a Sheet, triggered by date, goes out every day at 10AM est as an email to my team. However, updates we made today at 10:30AM are not included. Is there something we need to do?
-
Workflows updates
Hello, I wanted to know if there is functionality for the following: I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar. I then realised that if I needed to update anything on #1 (after the row was copied…
-
Merged: Pause all Automations. Helps when making sheet changes
This discussion has been merged.