-
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…
-
Merged: Move Rows to TOP of another sheet
This discussion has been merged.
-
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…
-
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…