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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!