-
Need a formula to have all work-flowed moved cells to go to the top of the sheet
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
-
Create a backlog item when status changes in a form?
I created an intake request form and it has a status field that on submission is set to Submitted as default. A email is triggered to the team that a new intake was submitted. The process then requires someone on the team to review it and set up a discovery session. Is it possible when the status changes from Submitted to…
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottom
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
-
Nightly Automation with Today Formula
I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker)…
-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
-
Is there a way to trigger a workflow following an automated update second request?
I have created a an automated workflow to send update requests 2x if a cell is blank. I want to create an automated assignment if the cell [Fail1] is not completed within a week after the second update request. Also, Fail1 has a formula to determine if a provider failed given 3 other criteria in other columns. Is there a…
-
how to find out if an email exists?
Hi all, I have a list of people with emails in my smartsheet. Some of them left the company, how can I find out from smartsheet that their email not exist anymore and to mark them in the sheet? Thank you, Joachim
-
How to create a deadline column for it to be three days before the deadline that was put in the form
I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get…
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…