-
Move rows automation is transferring the entire sheet, not just the rows that are "checked"
I set up the automation shown below to transfer a row to another sheet once a check mark is selected for said row. However, when the automation runs, it transfers the entire sheet to the "Past Eval Results" sheet, including the rows that are checked and not checked. Is there something I am missing in the workflow?
-
Need help finding a way to create an enrollment or disenrollment form automatically.
Currently we have a form that adds rows and "dealers" onto a program. I have been having issues finding a way to make that form or a separate form have a way to allow a drop down of the enrolled "dealers" where they can choose and add a reason request for that removal. If it is approved then have that modified row move to…
-
Merged: Move Rows to TOP of another Smartsheet
This discussion has been merged.
-
Removing duplicate rows in a sheet
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
Archiving Sheets with Different Primary Columns
My workspace has 3 main source sheets. Each of these source sheets currently uses a different column for the primary column (two use ID Number, one uses Name since ID number is assigned later) but both columns exist in all sheets. When a request (1 row = 1 request; form intake) is marked completed it moves to its…
-
On a sheet, can you have rows moved to the top?
We are using a sheet to track a project we are working on. I have set up conditional formatting so that when the project status changes to "Completed," the entire row greys out. Is there a way to move that row to the top of the sheet so that only outstanding items are displayed at the bottom? Currently, I have it filtered…
-
I have a Move automation it disappeared from first sheet but didn't appear on new one
I had an automation that I created that had previously functioned. Basically the user check a box in a column and once the check box is selected the row is deletes in the original sheet and should appear in the new sheet. I'm a little concerned because I used the move command and it disappeared from original sheet and just…
-
Can i move child rows to another sheet and copy the parent row across too?
At the end of each quarter, i'd like to copy parent rows and move the previous 3 months (from each parent row) to an archive sheet. Is this possible? I'd then like to have an automation after this that adds 3 new rows under each parent row once a new quarter begins.