- 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…
- Move a row form one sheet to another in a different workspace
你好,我想从一个表到另一行ther in a different workspace. I am the owner of the original sheet and I am the owner of the destination sheet and workspace. Is this possible as nothing comes up when o search for the sheet I want to move to.
- Move rows to another sheet Workflow - Select a destination sheet is blank
I have created plenty of sheets that have a workflow to move rows to another sheet. There were no issues to create those automations before until now. I am the owner of all of our Workspaces and sheets but for some reason Select a destination sheet window is blank. I have tried to sign out and in and tested with the…
- 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…
