Add specific column data to a sheet

Rob B

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

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

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?