-
Workflow automation to alert contact via email when assigned task
I have a task list, and an automation setup to send an email to a person when they are assigned a task, in the email it sends to that contact, it sends a link that sheet where the task is held. But when they click on the link it requires them to create an account and login to view the sheet. Is there a way to have the…
-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Copy rows to another sheet using workflow
Hello I have a workflow which triggers when a column (calculation) changes to value to anything above 15. The workflow then is set to move these rows to another worksheet, using a condition whereby status = 'open' from another column. All looks good, but nothing happens on the destination sheet when I run it. What am I…
-
Request an Approval now has the sheet link, why?
Does anyone know how to remove the sheet link option at the bottom of the approval workflow? When was this added, and why? This workflow should be treated the same as the Request an update, where it doesn't give the option to the approver to access the sheet. OR If approvers need more information than what would…
-
Automation - Workflow - Reminders when a date is reached
Hi, I created the below workflow to alert me 1 week before my due date column for a project I am working on smartsheet. I am not receiving any email alerts - I did check and I have all notifications allowed under my account so that is all good. Have I not set this up correctly maybe? Does it look okay or do I need to…
-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Why is this happening all of sudden?
Hi all, I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked. As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets…
-
Not all group members who have access are getting workflow notification
Hi, I have an automated monthly update request that gets sent to those in an owners column on my sheet, requesting they use a provided link to update a dynamic view. Those owners are part of a group I've created in Smartsheet, and this group has edit access to the sheet and dynamic view (and rest of the workspace). I…
