-
Move Rows to TOP of another sheet
For years, I have been using an automation, where when a specific row is checked, it triggers an automation to move a row to another sheet. I know this has been discussed in forms for a long time now, but would be great to have the moved row populate at the TOP of the sheet without having to manually sort a column to bring…
-
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…
-
Automation in Template not Working
I have a template that has an automation that moves rows at a certain time of day to another sheet. When certain users create a sheet using the template the automation is unable to run. with the error "unknown destination". I need some help. Do all users need access to the destination sheet as well? I want to avoid that.
-
How can I copy a row from sheet with cell links to antoher sheet? Reccuring workflow not working
Hi all, I am trying to COPY rows automatically when a project owner name is changed from the original sheet to a destination sheet. The original sheet has cross links to another sheet and hence, I tried to use recurring workflows. Neverthless, not able to find the desitination sheet in the search box. I have tried to write…
-
Move row to another sheet automation dropping contact
I am using automation to move completed tasks to another sheet; however, the assigned contact is not transferring to the new sheet. I have confirmed the format is the same in both sheets. Both are set up as contact columns. Has anyone experienced this and found a solution?
-
Data Shuttle + Data Table: Move Row Repopulation
I have a large Data Table that gets fueled daily with fresh information. There is a 'KEY' column that uniquely identifies each ROW of data. Using a Data Shuttle, I am fueling a regular sheet with only SOME of the data from the Data Table. Unfortunately I cannot find a way to filter the Table with ANY (and) ALL logic. What…
-
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.
-
INDEX/MATCH a good fit for updating a cell on another sheet?
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…
-
Merged: Move or copy just some columns to other sheet
This discussion has been merged.
-
Columns clogging downstream sheets
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…
