I'm using Smartsheet as a work order tracking system. Right now, I have a source sheet copying particular rows over to several child sheets based on the dropdown value of a column. I've experimented with moving rows back to the source sheet from the child sheets once modified, but it gets hairy because duplicates are…
This discussion has been merged.
Does anyone know of a way to limit columns moving from one sheet to the next sheet when leveraging Move Rows automation? I'm finding downstream sheets are getting clogged with unused columns and numerous blank cells. This creates confusion when training new employees, but also creates additional workload for managers who…
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?
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…
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…
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.
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",…
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…
