-
Copy Rows with Hierarchy
Hi, I have a sheet with hierarchy once one is marked delivered the row with the hierarchy under it moves to a purchased sheet. Once it is in the purchased sheet I would like it to copy rows that are blank with the hierarchy back to the main sheet. The automation is working if I force it to run but it is not working…
-
Making a copy of several sheets, reports, and dashboards
I have a workspace which rolls up multiple project plans and RAID trackers, into reports and then into a dashboard at project and portfolio levels with varying data widgets. I want to use this overall as a project template however I am noticing that when I try to save as new or duplicate the folder structure and underlying…
-
Automation Workflow Error
I'm trying to set up an automation and I am getting an error that says: "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet" Why am I seeing this error?
-
Autopopulating a job number
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year, and job number for the year. For instance, the first job of 2024 for Customer A with a customer number of 1000 would have a…
-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
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.
-
How do I automatically copy rows within the SmartSheet to a new row
I have a sheet and I want to copy an existing row of data to a new row of data in the same SmartSheet and change the value on one of the columns when its copied. is this possible?
-
Merged: Copy Form from Test Workspace/Sheet to Prod Workspace/Sheet
This discussion has been merged.
-
Why does my target sheet not show in search?
I'm trying to copy a row from an original sheet to a destination sheet. However, when I try to select the destination sheet, the search returns no sheets: I saw that both the original sheet and the destination sheet must be shared with Admin/Owner status. This is the original sheet: And this is the destination sheet: Why…
