I work as a delivery driver and have been futzing around trying to create a google sheet that automatically updates with the current day's drops. However, there is a rub with the data set. The publishers all use different "drop codes" denoting which day(s) a customer gets service. I have the different days drop codes on a separate sheet, same workbook (? googles naming convention is ridiculous)), in named ranges and generate the day's sheet with...
=FILTER(stats!A2:H, COUNTIF(daily , stats!G2:G))
...where 'stats' is a sheet with the entire route, column G containing the drop code for that customer, and 'daily' being the named range containing the drop codes relevant to that day. The drop code-named ranges being daily
, thurs
, fri
, sat
, and sun
. Notice the rub? Monday, Tuesday, and Wednesday doesn't change so they are grouped under daily
as they get service...well, daily.
The question: How would one go about changing the drop code set with the current day if 3 of the days repeat?
I realize I could do something like copy the daily column twice and have M, Tu, and Wed with identical cells or out the drop codes across rows having the call use TODAY()
to fill in the row number. But part of this exercise is to learn more about the deeper workings of spreadsheets and (hopefully) not make redundant massive clunky code blocks (like my python projects...). I imagine TODAY()
needs to be integrated around the drop code-named ranges, and I've poked around the TRANSPOSE
formula help page, but it's not clicking how to put it all together if that formula would work for this at all.
Any insight into the syntax of getting this to function would be much appreciated.