Column Search

Karrie Davis · 06/17/19

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.

lpm 2.PNG

Andrée Starå · 06/18/19

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 · 06/18/19

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 · 07/11/19

Hi Andre,

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

Andrée Starå · 07/12/19

Thanks!

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

Column Search

Comments

Categories