How to pull a series of columns from one sheet to another based on a date?

Wilson.springs

I want to know how I can pull the columns from date - county to another sheet based on the information being entered in the last year. This sheet is updated very often and I need to be able to pull these columns based on the market they correspond to as the sheet updates for only the last calendar year. For example, I want all of the Charleston - MCHS market information from investment through county to pull into another sheet based on their information being entered in the last year. the sheet will update so the formula can not be static. Thanks in advance !

Trish Dillon

https://community.smartsheet.com/discussion/112792/how-to-pull-a-series-of-columns-from-one-sheet-to-another-based-on-a-date

Do you have the datashuttle module? this could be done with datashuttle.

Wilson.springs

I do not, Is there any other way to do this

jmyzk_cloudsmart_jp

Hi @Wilson.springs

If you do not have to update last year's data dynamically, the following method may meet your needs.😀

1. Create a report with a specific range of columns and the desired filter.
2. Export the report to a Google Sheet or Excel file.
3. Import the exported file.

The demo below uses the Smartsheet Sales Pipeline template, creating a new sheet with a specific range of columns and dates using the above method.

https://app.smartsheet.com/b/publish?EQBCT=374acec9881c4ddfb82448f96d50bbe7