-
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…
-
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…
