-
Multiple workflows in a worksheet - "This workflow was triggered by at least 5 other workflows"
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st…
-
Request an update
I'm thinking of setting up an automated request an update workflow to go out to the assigned column once a week every Friday to manage the construction phase of my project. Only trouble is I want it to send an individual email to each contact in the assigned column not one big email. I have been setting up a weekly…
-
Automation Workflow Not Consistently Working
Hi! I set up an automation workflow on a form I created in Smartsheet. I have tested it twice; with one group it worked and each person received the email notification to approve or deny, however, the other group no email notifications were received to take action. I did not update the workflow between test groups and the…
-
Automated Message Workflow Changes Cell to #BLOCKED
I have a sheet that calculates a score based on responses from a form. In that form, the user can submit their email that is then added to a contact list column. I have also set up an automated workflow that shares the score from their submission to the email submitted on the form through a message. When the submission…
-
Making an order request form but need the ability for multiple items entered into the same order
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
-
Manual Override of Formula Index/Match for Out of Office with Column Formula
Hi All, I have an index/match pulling in data relevant to a Business Unit from off sheet. I need to get it so that I can override this formula data to be blank/allow entering of a different email address by the sheet user. What I have setup already (working with Column formula): 1) User inputs Business Unit (BU) 2) BU auto…
-
Formatting Rows under Parents
Hi all, Is there a way of creating a formatting rule where if a category from a drop down menu is chosen, that row will move under a parent row? e.g. we are doing a protective workwear smartsheet, we would like to categorise things by type of PPE - 'hand and arm protection', 'face protection', 'skin protection' etc.; once…
-
Allow Editors to select Approvers per line item
Hi, I'm trying to automate what is currently a manual process done by sending a PDF with 4-5 signature blocks out to various approvers via email. I have a Smartsheet that intakes form data from a submitter. At some point, that data needs to go through several layers of approval (supervisor, document owner, program owner),…
-
Automated Workflows Not Triggering
I have a very simple automation - email trigger when status changed. I has worked for over a year but suddenly stopped. I have duplicated, edited and updated the workflow and no change. I did see mention of making sure your cells/rows were not at the maximum, but cannot find what that number is. We are over 1300…
-
IF formula stops referencing columns after a certain point unless I manually type
I have a survey going to to people with 56 compliance rules. When the survey answers as "out of compliance" I have a rules column for each rule change that to a "1". Another column I've made have multiple selection options with the rule number and compliance issue. So Ideally when someone answers "out of compliance for…