-
Formula to move over one cell
Hi there! It looks like there's not yet a solution to move over columns/selected data from one sheet and merge it into another. However, I was wondering if I could move over one cell from sheet 1, based on an update in Sheet 1, into a cell in Sheet 2. Sheet 1. Approved Column is updated to "Yes, Approved..." Sheet 1.…
-
Time Triggered Automation with Conditions
I have an automation that is triggered twice a week. I have two conditions that need to be met, and if those aren't met, the automation still runs, but in the email, no rows are sent. I'd like to be able to set up an automation where if the conditions aren't met, a different alert goes out. When I first attempted this, I…
-
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…
