-
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…
-
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
-
Dynamic Formula
Hi! I'm using smartsheets to manage my business's projects and I have an automation that triggers when my PO checkbox is ticked, so that it copies the project over to a separate client sheet. Necessary so that I can keep all of my projects for Client A, B, C etc separate, for some specific calculations I need. (Mainly…
-
New copy of an old project
Hi! We have a long list of about 100 projects in a sheet - about 80 of them will be "restarting" or "renewing" this year. Instead of making the requesters fill out the intake form again, I'm hoping to save some time by copying rows from "this year's" request to "next year's" request, and just make some minor updates to the…
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.