-
We’ve made improvements to your copy and save experiences
Good news community, we’ve updated the speed of our Save as New performance, so now you can expect better, more reliable save behavior, especially for large folders and workspaces. We’ve also made improvements to the dashboard copying experience. Specifically, we have enhanced form relinking in dashboards, a feature that…
-
Automation / VLOOKUP help
Hello! My initial gripe comes from wanting to copy only certain cells from a row into another sheet. I've read a bunch of the threads for create a helper sheet, add dummy columns, and then use VLOOKUP, but I just cannot get it to work for myself and I'm uncertain what I'm missing! I have Sheet A that contains all my raw…
-
Formula to mark duplicates with a Status of 2 or 3
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake sheet generates a project ID and then when the project gets to a certain stage, it copies to my Active project sheet, but…
-
Merged: Copy Datamesh As New
This discussion has been merged.
-
Copy Rows Automation
Hello, I am setting up 2 sheets. One Master Sheet and the other - User Sheet. I am setting a copy row workflow automation so that every day at 5pm rows added to Master sheet are copied to the user sheet. Before i implement and test this, i am wondering: Will Smartsheet know to copy only rows added that day(masters sheet)…
-
Merged: Copying Columns
This discussion has been merged.
-
Copy to other Smartsheet when row is added or UPDATED
I have two sheets, lets say A & B, which are currently blank and will be used to gather patient information. I'm trying to copy anything entered in sheet A to sheet B including if an updates have been made (e.g. if a name is entered incorrectly in sheet A and later corrected, sheet B will be updated in the same row and not…
-
How do I copy value only from cell formula to use outside smartsheet
Here is my dilemma. I have to create a cell that takes the results from other cells in the same row and formats all of it into a single text string. This is so that other team members can take the resulting string of text and paste it outside of smartsheet. However, when I go to copy the result, it only copies the formula…
-
Copy Sheet w API doesn't copy over "Cope Rows" Automation action
I am using the Smartsheet SDK When I copy a sheet using the API (either by copying a template w/ client.Workspaces.create_sheet_in_workspace_from_template or client.Sheets.copy_sheet) I can use the "include" query parameter to capture conditional formatting, forms, and automations copy over, but a specific COPY ROWS action…
-
Latest Comment Copies Wrong Time
I have two columns that I have users enter data, formula combines it with the current modified date and time, then automations copy those rows to another sheet, so the history is preserved with the time. I then use the JOIN/COLLECT trick in new columns on the original sheet to show a log of that data change over time. One…