-
Workflow to change a cell value isn't working properly (changing the values I input)
I have several workflows to auto-populate a required reading column value based on what procedure is being performed. Most of them work just fine, but a couple of them are changing when they auto-populate in the sheet. For example, I have the required reading for a specific task as "3941, 3987" but when the cell…
-
Workflow to send out FIRST attachement in a row ONLY
Hello Smartsheet Community, I would like to send out an attachment via a workflow (Alert somebody), however this workflow should only start automatically for the first document which is attached to a row. Background is, that an attachement is created automatically by another workflow (=Generate document). This document…
-
Workflow - when box is checked
Hi there, I feel like this is an easy one, but for some reason I'm a bit confused about how to get it done - I want to trigger an alert when a box is checked - either when the row is added or when it is checked at a later point. I was going to do 'when rows are added or changed' and 'xx' box is checked, but, I don't want…
-
How to reinitiate approval cycle after the proposal is declined ?
We have a workflow whereby we send a proposal with estimated cost and delivery date to our customer which he will be presented whirch two options (approve/decline) .If its approved then we can start the work fine, however if it is declined we would idealy like it to come back to us with the reasons for rejection and maybe…
-
How to add multiple contacts in one cell with an automated workflow?
Hi there! I currently have automated assignment workflows where when a certain department is selected, the Department Manager is populated according the specified workflow. My question: is there a way where two department managers are assigned in one cell when two departments are chosen (I have two separate workflows for…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
-
Upload Thousands of Excel Documents to Rows
I have been building a workspace for inspection tracking. Before this we were utilizing an Excel doc that would use a macro to create a new Excel doc for each inspection with the information that was entered. There are 2332 excel documents. The information in each doc are not in individual columns. The filenames are Asset#…
-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
-
Copy row with no hierarchy on one sheet and make it a child on another.
I have a been working on building a asset inspection tracking workspace. I currently have 4 sheets built for it. The first, Asset Master List, has all of the assets and information about the asset built into it. This sheet was built from an Excel Import. The second sheet, Inspection Form, has all of the form responses for…
-
Workflow - Not running when sheet is not open
Hello, I'm using the JIRA connector and when a sprint is closed and another one is opened, I'm tracking that change on a smartsheet sheet. I would like to have a workflow to perform a few actions upon that change when that change occurs. The sprint does not start always at the same or at the same time of the day, that's…