-
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.
-
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…
-
Automation is moving all rows instead of only those that meet the condition
Hi All, I have automation set up to only move rows where the summary checkbox is checked*. I added summary 2 and 3 to run more tests since this isn't working correctly. No matter what column I choose for the condition (Summary, Summary 2, Summary 3), it's still moving all the rows. I have no clue what's happening here so…