-
How to set up automatic notification when entire column meets the criteria?
We are trying to build a monthly checklist with various tasks our team members need to complete. Some of these tasks need to be completed before another task on the checklist can be completed. Specifically, we need our users to upload their payroll cash batches into our accounting system before another user can populate…
-
LookUp Results then Automate Resonse
Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo…
-
Sheet automations and cell updates
We have a recruiting team for our clients. When the client requests us to fill a job role, they can specify one or more jobs in that role. When the recruiter fills one job, I copy the row to another sheet for billing, then I want to reset five key fields and decrement the number of jobs to fill. Does anyone have any…
-
Unable to Run Copy/Move Automation
I have several sheets in which I utilize automations to move/copy rows from one sheet to another as the rows move through our workflows. So of course, each subsequent sheet has duplicate column names. I had to make a change that ended up completely breaking all of these move/copy automations. The change that broke…
-
Email Delivery Change -Automation
Can we please make who the email automations are from editable? All of my automations come from me and I would much rather make it from our group or organization. (Or vary it based on the end use/user) Thanks so much.
-
Change Cell Value with Automation Workflow
I have a scenario where three people are providing an update on a project from different aspects, we have 3 fields for each person so the update requests prevent people from overwriting others update. We then would like to concatenate the 3 fields into one. Putting a formula into the field makes it hard to read without…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Automation: Sender issue
I have 3 coordinators working from the same sheet. Their case load is determined by last names, A-L and M-Z for the 2 coordinators and a specific program assigned to the 3rd coordinator. Anyhow, the delimea we are having is that when the automation for assignments go ount on trigger, it appears that it is coming from the…
-
Automation Copy Rows - Select a Destination Sheet
Hello, I'm running into an issue I've found through past forums. I'm attempting to copy rows from one sheet to another. I am the owner on both sheets. What could be the cause of this? Both sheets are in the same folder… Thank you
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
