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 numer…
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 c…
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 …
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 …
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: St…
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 d…
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 n…