-
seeking to establish a cross-sheet workflow to transfer a cell value to another sheet when a drop do
Hello, I'm seeking to establish a cross-sheet workflow to transfer a cell value to another sheet when a drop down option is triggered. I have tried the row transfer workflow but it transfers the entire row, when I'm only seeking to transfer a select cell value in that row when triggered. Any assistance would be greatly…
-
Is it possible to get rows automatically sorted in a sheet as new rows are added?
I have several sheets where it would be incredibly useful for them to automatically sort as new rows get added & cells change. Is there a workflow I can set up to do this so it automatically sorts on some kind of timeline (daily, weekly, etc.)?
-
Survey Form Automation & Teams Integration
I've created a form for the HR Dept to collection employee appreciation submission. They want all submissions posted to the Team group. I was able to complete all the required ask except I can't figure out how to remove the link <GK Shout-out Submission Form> at the top because they don't want anyone to have access to the…
-
Automation Alerts Not Sending When Change Cell Action Is Included in Workflow
I have several workflows on a sheet that alert the people in a Contact Column when certain events happen in the sheet . . . Invoice Paid Date added, Row Added, etc. Everything seemed to be working until I added a Change Cell action after the Alert action. Once I added the Change Cell action, it would run but the email…
-
automated alerts triggered by number of entries
Hi, I've been asked to help with a form. They'd like to cap the number of entries at 100, and I'm not sure that can be automated. They'd also like to receive alerts after 25, 50, 75, and 100 forms are submitted and new rows are added. I see a way to get an alert after certain dates, but not in the number of entries. Is…
-
Edit destination sheet when changes are made to a source sheet
My organization has multiple divisions working on several projects, so each division has their own project management sheet to track project timelines, tasks, budget, etc. I was hoping to have each division's sheet automatically update into a larger organization-wide project management sheet so our executive leadership can…
-
Move row to another sheet based on cell - not working properly
Hello everyone, I've been trying to figure this out on my own for a few days but haven't been successful. Error: Workflow states move row if a column contains one of ten options. Workflow moves all rows for all options. Example: Drop Down Options: Not Started, In Progress, Complete Sheet 1: Task Sheet Sheet 2: Completed…
-
Automated Workflow...What is the best way to optimize the Update Request?
Hi, I am trying to set up an automatic workflow that will send a notification to users who have tasks assigned to them on a weekly basis (recurring) to get status updates. I have created the following request with a custom message: However, some users are not seeing the customized message, so they are unaware of the task…
-
Using Conditions in Workflow to alert when quantity doesn't match
Hi all, I am trying to figure out how to set a workflow to alert a contact in a contact cell when a "qty recd is less than "qty on order". Ideally I would love an email to kick out that says Your qty rec'd is less that qty on order, but I cant seem to figure out how to finagle the workflow. Under conditions I have selected…
-
Does Smartsheet have a way to create a flow chart for account current pages?
Does Smartsheet have a tool that could map out the pages within my organizations Smartsheet. Like a work flow diagram that shows where the pages go, what reports link off these pages, what dashboards they are attached to etc. Maybe even what/who is linked to the Automation's. What automation's are included on the page and…
