Is there a function to use the "Copy Row" Automation flow to send rows matching the defined criteria to a newly generated sheet each time rather than to a pre-defined existing sheet?
Unfortunately not. Copy Row and Move Row must be pointed towards a pre-existing sheet. They cannot be used to create sheets.
It is a great idea though. Feel free to Submit a Product Enhancement Request when you have a chance.
The third-party service, Zapier might be an excellent option for this scenario. Is that an option for you?
I hope that helps!
Have a fantastic day!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Copy row does create the rows from the original sheet in the new sheet however. I just used this feature to quickly build 26 sheets for a project. You just need to go into each and delete the extra 4 columns afterwards.
@L@123 Not sure I follow! Can you explain in more detail?
If you have a created sheet with the correct column names, you can make a new blank sheet, create your copy or move workflow to the unedited blank sheet, and it will populate the blank sheet with the correct columns after the first submission.
It just a quick way to split your data up. I suppose it isn't that much different from saving as the sheet but this way you don't have to worry about deleting workflows and conditional formatting and previous data if that is an issue.
*I said rows in my previous comment, i meant columns
Yes. But that sheet must be created before you can have it populated with the new rows.
I think the posting is trying to have rows moved to a sheet that is not yet created but will be created once the first row triggers the workflow.
While it will add the columns to a pre-existing sheet, that sheet must still be pre-existing before rows can be moved/copied to it.
"I think the posting is trying to have rows moved to a sheet that is not yet created but will be created once the first row triggers the workflow."
-- Yes this is the functionality i was inquiring about. to generate a new sheet at the time of workflow trigger. It does not seem that this is feasible at this time. Thank you all for your help.
Yeah I understand that. I was just suggesting a way to make it faster manually because fully automating it either requires coding or an external service. Sorry if that wasn't clear.
Happy to help! 👍️
Happy to help!
@L@123 Ah! Goddam it! I thought you had a special trick!
@SSI Front End You could probably do it with Zapier. Do you want to explore it?
Microsoft Flow or Zapier can do this.
@Ramsay Zaki Yes, Microsoft Flow is another excellent option. I prefer Zapier!
I wanted to bump this thread. Has this feature been introduced since this discussion? I started looking into Zapier and Microsoft Power Automate, but didnt want to waste time getting familar with them if I didn't have to.
Thanks in advance
@Andrée Starå @Paul Newcome
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.