Copy Row by Automation

I'm copying rows that meet specific criteria from multiple project sheets into a single different sheet using an automation. When looking at the destination sheet, is there an easy way to determine what source sheet each row came from?

Similar question for reports - If a report is collecting data from multiple different sheets, is there a way to group the data based on the source sheet it came from?

Find more posts tagged with

Reports

Automations

Workflows in Smartsheet

Accepted answers

Paul McGuinness

HI @Chadd

Simplest way to do this is to have a hidden column in each sheet with a column formula to add a sheet name into the cell when other data is added to the row.

i.e. ="Sheet 1" (or whatever works for you), make sure it is a column formula.

You can use that to identify where the row of data came from and to sort or filter the data in reports.

Hope that helps

Thanks

Paul

All comments

Paul McGuinness

HI @Chadd

Simplest way to do this is to have a hidden column in each sheet with a column formula to add a sheet name into the cell when other data is added to the row.

i.e. ="Sheet 1" (or whatever works for you), make sure it is a column formula.

You can use that to identify where the row of data came from and to sort or filter the data in reports.

Hope that helps

Thanks

Paul

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.