0

Columns= based on date filter in specific columns

Dorka Cruz

April 16, 2018 15:37

None

Follow

In the attached report I'd like to create additional columns based on a date filter.  I’ve highlighted the cells where I want the columns (S7, AB7 etc) added for each month between 1/1/18 – 2/28/18.  There are other columns where I don’t want them to change but to be what is already there (column N – R, W-AA, etc.). The current formula I'm using doesn’t seem to be cooperating and I don’t know if it’s due to the order in which I’ve put things.  Any guidance would be greatly appreciated.

I tried attaching the report but couldn't find the option so hopefully this screenshot will show how I've entered the function.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Heather Rowe April 16, 2018 16:46

  You need to point the "Period Start" filter at a cell that contains the entire period - not just the start period.

  so your formula should be something like: =nl("columns=1","date","period start","period start",$U$8,...)

  but just to keep everything clean, I would probably move the 1/1/2018..2/28/2018 reference to one of the hidden columns to the left, and then reference that location (if you need it in U8 as well, you could always reference the new location)