Add specific column data to a sheet

I have seven (7) sheets that track dates for activities in our facilities. Not all seven sheets have the exact same columns but they all have certain columns that I would like to consolidate onto a master sheet for reporting and metrics. The copy row automation, as you already know, copies the data for all of the columns. Based on the status change of a particular column I want to copy only a few of the columns into a single sheet as a new row in that sheet. How can this be done if there is nothing to do an index match on.

For example

When the Status = Shipped copy the required columns and dates to a new sheet

Screen shot 1 is the source that has more columns than I need in the destination sheet

Screen shot 2 is the destination sheet I want to copy data to

Find more posts tagged with

Automations

Cell linking

Accepted answers

Anson Cheung

Hi Rob, I think you should try out the Row Report. It can capture the changes of your sheets on specific columns and with filtering logic in real time for reporting.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder

--Anson

All comments

Anson Cheung

Hi Rob, I think you should try out the Row Report. It can capture the changes of your sheets on specific columns and with filtering logic in real time for reporting.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder

--Anson

Rob B

Thanks @Anson Cheung This is exactly what I needed!

Rob B

Actually the report only got me half way there. I now need to get the consolidated information into a sheet, not a report, so that I can use Zapier to move the info to an internal tool for metrics. Any idea on how to do this?

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.