-
Move row workflow not running
hello i have run into a problem where i have a workflow setup that automatically moves a row to another "Active" sheet when the decision column is set to active, and it works fine when i do it manually but i tried to add a vlookup formula to pull from another sheet that is filled from a form since you cant use forms to…
-
Multiple Time Based Alert Workflows
Hello, I have two alert workflows: 1) Send an alert to contacts in a cell on M/W/F at 11:00a.m. 2) Send an alert to contacts in a cell on T/Th at 5:00p.m. My question is: In this scenario, does the workflow only look at the day it is scheduled to run? i.e., Workflow runs at 11:00a.m. on Monday, looking at all changes made…
-
Automation / Formula to separate text from flight information
Hello, Is there a way to separate the text from a flight booking straight from our travel system into separate Smartsheet columns? This is the data we receive in our travel system when booking a flight : BA 990Y 10NOV 4 LHRBER SS1 0710 1005 I would love to be able to move this data into several columns in Smartsheet:…
-
automation update request - parent & child rows help?
So I have a list of tasks with parent an child rows, see below example of 1 task with 5 children: I want to make an automation to send an update reminder prior to the due date I do not want it to send individual emails for the parent and child rows I just want it to send an update on the parent rows with child rows…
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Sheet Row Limit - Automation Recos / Suggestions
With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue? My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated…
-
How do I email a central database of contacts?
Hi Everyone, I have two separate sheets. Sheet 1 is a database of all my different suppliers, which has their name, email, and specific item which they supply. Sheet 2 is where I specify what item I would like to procure at a certain time. Once I specify the item I want to procure in sheet 2, How do I automate an email to…
-
Duplicate Automation Email
Hi all. I am trying to notify a coworker when a customer has multiple entries on our sheet. I currently have it set up so they are notified, but it only includes the new line that was added showing it was flagged as a duplicate. Is there a way to have the email show both rows in the email notification?
-
Upload Data Shuttle Flow Deleting Rows in Target sheet
Hello Smartsheet group, I am facing the same issue trying to test an upload workflow. I have created an upload workflow that will pull from OneDrive - XLSX file and replace the rows of information into my target Smartsheet file. For some reason the target Smartsheet file is only deleting the rows of data and not uploading…
