Automations
Discussion List
-
Automation 'Copy to another sheet' doesn't workIn Formulas and FunctionsI have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automatio…
-
Formula for showing subtraction/sum compared to totalIn Formulas and FunctionsHi there, I'm working on testing quality assurance of products sent to my company. For each row in my Smartsheet represents one product I am testing. Each row requires testing on 160 samples. In my reports I want to show the "Result S…
-
Row Copy AutomationIn Formulas and FunctionsI have two sheets - a Checkpoint sheet and a project RAID log. If Action Required is set to YES on the checkpoint sheet, the copy row automation should trigger to copy the row from the checkpoint sheet to the project RAID log. I have hidd…
-
Can I create automated survey feedback to a user in SmartsheetIn Formulas and FunctionsI'm new to using Smartsheet and I'm trying to design a survey with automated feedback to the user. I'm wondering if Smartsheet has the capability to do this. Here is an overview of what I'm trying to do. I have created a survey that will b…Answered - Pending Review 15 views 4 comments 0 points Most recent by Lucas Okwudishu Formulas and Functions
-
Vlookup cell isn't multiplying with another cell.In Formulas and FunctionsHi guys whenever I am trying to multiply my Vlookup cell with another cell it gives a Value error. I have linked web data to other sheets and have a vlookup for specific data in cell D6. In G6 I then want to multiply D6 by a value in F6 us…
-
Can I sent an Alert in a sheet (column) to a Smartsheet Group?In Using SmartsheetWe have a sheet that a "group" works, I want to send an automated email to the "group" that a line has been added. I have created the "group" in Group Management. What would be the best column type/ column pr…
-
Automated Workflow - Alert NotificationsIn Using SmartsheetHappy Friday SMEs! Is there a way to confirm an automated workflow "Alert" actioned properly. For example, when generating an "Update Request", you can validate if/when the request is completed by referencing the tool…Answered - Pending Review 14 views 2 comments 0 points Most recent by Edwina Sampler-Wright Using Smartsheet
-
How to block a cell on formulaIn Formulas and FunctionsHi, I want to know how can I lock a cell in a spatial working formula. Example: = IF (AND ({PROJECT CASE TEST Rank 7} = January1, {PROJECT CASE TEST Rank 6} = January2), {PROJECT CASE TEST Rank 8} + {PROJECT CASE TEST Rank 9} * January5, …Answered - Pending Review 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Automatic Workflow Email Trigger for Dependency RowsIn Using SmartsheetDo we have the option to send an email alert to the next person in the activity once the prior activity is marked as completed? I tried to do this using the "Request for Update, but this doesn't work. Could you please help?
