-
How can I create a Task/ To-Do List for each team member?
Hello, Looking to develop a task list for team members from our Project Tracker. Our sheet runs left to right and uses Column Headers to organize information rather than using Parent/Child row hierarchy. Currently, each step of the project has an expected completed date (automated by formula), an actual date column…
-
Large Sheet Notifications
We have a handful of very intricate, detailed, and logic-filled intake forms that are tracked in 3 separate master sheets separated by the type of intake. Each sheet is over 150 columns wide. We need to send a copy of the entire submission to the person who submitted it, along with several others selected in contact fields…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Can you create multiple workflows if you have too many actions for one?
Hoping this is an easy question. If you have an automation workflow that reaches the limit of blocks (too many actions), can you build a second workflow to pick up where you left off, or will that interfere with the first flow? My example is Condition path 1 - if state=X, request an approval from StateX email contact, if…
-
Sending to contacts in a cell - How to limit who is contacted
I have an automated workflow that triggers an approval request once a form is submitted. The workflow is set up to alert contacts in a cell when the request is submitted. The contact list that would be alerted is the request approver. The approver is just one person from a list of approvers; I have another workflow set up…
-
Move row to another sheet automation dropping contact
I am using automation to move completed tasks to another sheet; however, the assigned contact is not transferring to the new sheet. I have confirmed the format is the same in both sheets. Both are set up as contact columns. Has anyone experienced this and found a solution?
-
Automation Workflow Error
I'm trying to set up an automation and I am getting an error that says: "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet" Why am I seeing this error?
-
Alert - Send to contacts in a cell not working
We have a simple trigger to run when rows are added/changed to alert the task owner (contact column). Its set up as "Send to contacts in a cell" and none of my users are receiving the emails. One user received 20% of the emails… but like 5 hours later. When I run test on a row… I receive the email no problem.
-
Getting Smartsheet to Take a Snapshot of a Daily Report in Outlook
Hi Everyone! Every morning, I receive an automated email in Outlook with a report that includes different tables. I am creating a Smartsheet dashboard and was wondering if Smartsheet has the capability to take a snapshot (a physical image) of that report each morning and have it appear in my dashboard. Any ideas are…
-
Way to see all workflows across all workspaces?
I have an issue where it appears i have an automation running somewhere but i cannot locate it. Is there a way to see all automations across all spaces or do i have to go sheet by sheet to find it?