-
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…
-
Use workflow to copy multiple rows
Is there a way to copy multiple rows in a sheet to another sheet while using the run on trigger? Whenever a row is added to a sheet, I want all the rows that meet a condition in that sheet to copy over, not just the row that was added.
-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
-
Is there a way to set up automated reminders for just specific columns in a sheet?
I'm working on a sheet that has lots of columns, so want to create an automation to remind people to only update specific columns on a biweekly basis. Is this possible?
-
Any ideas on automatically creating workscope packages base on changed rows?
I have a large database that users can make changes to, those changes are then put into a workscope for processing. I don't think I want to use the highlight changes feature, because sometimes the changes may stay in limbo before processing for more than a month or two, and I don't want to use show changes since I last…
-
Forms - "Open-access" approval option?
Hello! I've created a form that we are using for eTimecards. (Working with a pilot group now) Currently have the person entering the form also entering their approver's email (approval flow routes to this person as an update to add additional details and approve/deny triggering the next flow) My initial thought was that it…
-
"Copy Row" Automation workflow creates duplicates in final sheet
I have one sheet where we catalog all the estimates that we do. Each row is an estimate and there's a column that has the contractor for that job. I made a workflow where this sheet copies each row that is marked with a specific contractor and sends that copy to another sheet I made to catalog that specific contractor's…
-
cannot edit existing automated workflows
I am trying to edit some existing workflows and when I click the edit button nothing happens I can still create new ones if use the templates but when I click create from scratch nothing happens as well... it was working fine yesterday, any one got the same issue or I am dealing with an isolated case here?
-
How can I use a cell value as the To: email address in an "Alert Someone" action
I searched the community and likely I am not asking this question correctly as I cannot find an answer. Background: I have a master worksheet with one row for each project. For each project I keep track of the person submitting a project request by saving their email address in a "Submitted by" column. Requirement: I want…
-
Resubscribe to workflow
Hi. I had 2 outside users accidentally unsubscribe to an automated workflow. How can I resubscribe them so they can receive the automated emails again? Below is the screen shot of the workflow properties