-
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…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
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 pull data from rm.smartsheet.com to smartsheet.com automatically?
Hi, We're trying to automate reporting, to prevent having to manually download data from rm.smartsheet.com and edit in different programmes e.g. googlesheets. Is it possible to automatically pull data from rm.smartsheet.com into smartsheet.com, which then feeds into a project dashboard in smartsheet.com? The only benefits…
-
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.
-
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…
-
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…
-
Merged: Run Workflows on a concurrent schedule or group workflows to run in select order
This discussion has been merged.
-
Copy row when certain criteria are met and edit data within the row
Hello, I am managing a list of products where our customers often re-order the same product the following year around the same time. I want to copy the product specifics to the bottom of the sheet once it is checked as delivered and add a year to the due date. This will allow us to plan for the product delivery the…
-
What do I do if my automations keep failing?
Good afternoon, We are trying to have data moved from one sheet to another every month using automations but we are running into the issue that once the sheet gets too big (too many rows) the automation will fail to move specific rows out. I am looking for a solution for this issue and an alternative to manually copying…