Column Search

Karrie Davis

I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I just highlight the columns that to use and the people but is there another way to do this so I'm not creating new formulas every week.

Andrée Starå

Hi Kari,

Would it work if we structured the sheet with the dates on the rows instead of the columns? 

Can you show more of the sheets so I can see the structure?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I generally follow something very similar to Andree's suggestion. Depending on the amount of data and the use of that data, I will set it up two different ways.

.

1. Make everything a date column, put the date in the top row, then reference row 1 in all of my formulas.

.

2. (Most often used for me) is to use three additional rows. One for day, one for month, one for year. I can then reference the cell in the same column on the appropriate row for whatever portion of the date I am trying to use as my criteria.

.

Some of my other sheets are also broken down by week number and year.

Karrie Davis

Hi Andre,

 

I just shared two sheets with you. Please let me know if you need anything else

Andrée Starå

Thanks!

I'll take a look and get back to you soon!