-
Data Shuttle Issue - Map Fields To columns - Sheet Column Names Not Populating
Data Shuttle is not pulling in column names from my target sheet. I am building an upload workflow - pulling in data from a .csv attachment to update a dropdown column in my target sheet. The sheet column names in the mapping table all show generic names, e.g., Primary Column, Column2, etc. - see attached. I clicked…
-
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Copy Rows to Another Sheet not working - Column has the same name as a system column on the source
Help please. I am trying to set up an automation that copies data from my Main Purchase Request Sheet to my Line Items Sheet. However, I keep encountering an error message stating, "Rows can't be added to the destination worksheet because a column has the same name as a system column on the source sheet." Here are the…
-
Why does my date automation disable with work management connected to column?
I have a intake sheet. When a new row is added, automation records the date in a column. I want to use the project added column as a start date in the Resource Management but I get a error shortly after when connecting, saying automation is now disabled. Is there something I'm doing wrong or I can be doing differently?
-
Workload tracking in Smartsheet with Parent Rows only
Hey, I'm so lost lol. I want to use the Workload tracking but read a article that allocation only worked with Child rows. My intake form doesn't have allocations. I'm trying to understand how or if this can work on a tracker with only parent rows. I also have automaton when the row is copied from another sheet for the job…
-
Can you create a workflow to copy a row to between sheets in different Workspaces?
I'm creating a workflow that copies a row from one sheet to another, wherein the sheets are in different workspaces. I saw that you must be an admin or owner on both sheets to do this and I am listed as an admin on both sheets. However, the sheet name I'm copying TO does not appear in the search results. But, sheet names…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
Trying to set up Corrective Action system using smartsheets
My company has been using smartsheets for order tracking and data reporting, but I'd like to try to use it for our corrective action system (we are AS9100). Currently we just use a controlled document to gather all of the data and put it in a folder that's manually created on sharepoint. I want to create a sheet to track…
-
Merged: Automation to assign a new row as a child based on criteria
This discussion has been merged.
-
Workflow - Generate Document - New Row Added from a Form
My workflow is as follows: When a new row is added (via form submission) and the "Type" field is a specific selection, e.g. "Business Operations", generate the document "SSV_Business Operations". See screenshot. However, the form is not being generated. What am I missing??