-
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…
-
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.
-
Microsoft Dynamics D365 Finance and Operations
There is only a connector for Microsoft Dynamics D365 but our company uses the Finance and Operations Dashboard for Microsoft D365. It will only pull information from CRM and there's no connector for the Finance and Operations information that we track. We have to manually enter that data currently because the connector…
-
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?
