Can I use a workflow to copy a row to a different sheet?

I know that I can use a workflow to automatically move a row to a different sheet, but I was wondering if there's a way to copy it? When manually using the 'Move to Another Sheet...' function you can alternatively choose to 'Copy to Another Sheet...' which is what I'd like to do.

Find more posts tagged with

Comments

Andrée Starå

Hi Kirstine,

Not yet, but it's in the works. It might be possible with Zapier in the meanwhile. Is that an option?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Kirstine

I've never used Zapier and have just had a mooch...! It doesn't seem like I can use a specific trigger like Smartsheet can. I want the row to copy across ONLY once the status has been set to completed.

Andrée Starå

Yes, fortunately, you can!

You'd add a filter to the Zap!

Click the plus sign between the 1. and 2. step to add a filter.

Make sense?

Kirstine

Perfect! I've done that but now it's saying there are no rows in my Sheet (there are 423!). I will try again tomorrow.

Andrée Starå

Strange!

Feel free to share some screenshots or reach out if you get stuck!

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto