conditionally copy to another sheet

I'd like to configure my sheet to read a single column and copy only certain columns to another sheet.

Example: in the second column I have these options from a dropdown menu: apple, banana, carrot

If "apple" is selected I only want columns 1-4 and then columns 8 and 9 (of 10 total columns on the original sheet) to copy over to the new sheet for just "apples" from the original sheet.

Any help is appreciated and let me know if I'm not explaining this well enough.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Is there a specific reason why you are wanting to use a copy row automation as opposed to a report?

critter

Hi @Paul Newcome - I'm still learning Smartsheets so I might not be going about it correctly but our business is trying to share only necessary information with other vendors so that's why we want to share only some columns and not all columns. A report wouldn't work for sharing the details for each row that we need to communicate, at least how I understand it.

Andrée Starå

Hi @critter

I hope you're well and safe!

Have you explored using the Premium App, WorkApps?

Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

critter

Hi @Andrée Starå - thanks for your response. I'm not sure if I have or not. Where can I find more info on them?

Andrée Starå

@critter

Happy to help!

It's included if you have the Enterprise plan or higher.

More info.

https://www.smartsheet.com/platform/workapps

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.