-
How do I automatically copy rows within the SmartSheet to a new row
I have a sheet and I want to copy an existing row of data to a new row of data in the same SmartSheet and change the value on one of the columns when its copied. is this possible?
-
Merged: Move/Add row automation: The ability to choose if the row populates at the top or bottom of…
This discussion has been merged.
-
can we create an automation or other method of removing columns
So I've been trying to figure out a way use have an automation transfer lines to a new sheet but then remove the extra columns. I'm ok using a helper column and then transfer it to a 3rd sheet but I cannot figure out a way to do it. Basically I have several sheets I want to create where a long sheet gets transferred to…
-
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.
-
Copy and duplicate Rows based on value in cell
Hi there, I have the issue where a user is attempting to duplicate the cell value within a sheet, based on a trigger, and a quantity. For example: Form intake produces a row with the values Column: Status = "Requested" Column: Quantity = "3" Column: CODE = "ABC" I would like when the Column: Status changes to "Published",…
-
Issue with mystery rows moving to a sheet
Hello all, I have an automation rule on my sheets to run at 8am every day to copy a row and move it to another sheet if the row has an end date that is in the past. However, only in the past several days (right around 8am), I am getting rows in the destination sheet that have expired dates from the beginning of June. These…
-
How do I move certain values from one sheet to a different sheet?
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…
-
Need advice on moving auto numbered data to another sheet with other auto numbered data.
Hello, I'm wondering if anyone has a work around for this scenario. I have two sheets: Sheet 1 - New Project Requests - includes the auto numbered column NPR ID# Sheet 2- Active Projects - includes the auto numbered column PRJ ID# When an NPR is approved for work I want to copy the row data from Sheet 1 to Sheet 2 but each…
-
Moving large amounts of rows
I'm trying to move 10s of thousands of rows. Automation does not work, it usually fails after trying for a few minutes. Is it possible to save sheet as new but retain the "created date" data? I need to move the rows one way or another without changing any of the fields (modified column doesn't matter in this scenario) I've…
