-
"Move row" automation option for "origin sheet"
I have a few Smartsheet solutions in place where a sheet is a destination for "Move row" automations from multiple sheets. For example a "Completed" sheet could have rows moved to it from 20 other "Active" sheets (each active sheet having a "Move row" automation to move rows at the end of each day when all checkboxes are…
-
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…
-
Merged: Select columns feature in "Move a row" automation
This discussion has been merged.
-
Moving rows to top of destination sheet
Hello, I have set up the Automation successfully and the rows move sheet to sheet using a condition but; How do I move a row from Sheet 1 to Sheet 2 so the row is placed at the top of sheet 2 instead of the bottom of sheet 2.
-
Using form to add rows to a specific category
I have a sheet that is used to keep track of each team members tasks. The tasks are broken up into categories and I wanted to have a form people could fill out to create a new task from their dashboard, but it seems the form always just inserts the new task at the bottom of the sheet. Is there a way to make it so that the…
-
unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
-
Move Rows and Old Columns added to new sheet
I'm trying to move a single row to a different sheet, but I don't want the columns from the original sheet to be copied over as well. Is there a way to avoid this? Whenever I try to move the row, it also brings the columns from the original sheet, which I don't want.
-
Column and Row Transpose
To whom it may concern, It would be very helpful to have a simple feature to View Columns as rows and vice versa within a sheet. A simple setting to allow the column headers to appear as rows and row information to appear on top. With the associated cell data still in the correct position. Please and thank you. Kindly, Dj
-
Merged: Increase Row Limit in Worksheets
This discussion has been merged.
-
Sequencing automations with no condition/trigger overlap - clearing top row after an automation
I'm hoping you can help! TL;DR in the weeds - I'm looking to use a change in the sheet to trigger an automation - but only act outside of the actual trigger TLD;DR big picture - I actually simply want to run two automations sequentially. As far as Smartsheet can tell they are entirely disconnected. (Their connection runs…
-
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.
-
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…
-
Merged: Move or Copy Row Automation should allow for Select Field handling
This discussion has been merged.
-
Limited Capacity on Sheet and Loading Time
I manage creative services projects for a large healthcare organization, we use one sheet that has several linked reports. Loading time is slowing due to the large number of cells and I will need to move rows. I have asked this question to the SS support team several times and have not gotten an answer. “Could you please…
-
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.