Re: Formula help

Well conceptually what you would do is to create a date field on the Admin record called 

[Reporting Date]

Then look that up down to the detail records.

Then every place that you have used summary filters based on date, you would need to not use or the "current week" Today but you would have to use that Reporting Date field.

You will likely find that you need some helper field to get the filters to work.  You can post back with a screen show of your filers on summary fields if you get stuck on how to convert them to use the reporting date.  You will also need ot create date fields to label some of your fields on the reporting Admin record so the user is aware which week or which the column represents.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

With you current design the report will change on its own each week but the previous weeks will not be accessible.

I do have a comment on the layout.  The readability could be hugely improved by suppressing all the field headings except the first row (current week last week etc)  and moving the words like 
Incoming to Answer and Answer to send to be beside the rows.

Then it would look more like a tight excel sheet with row and column headings and just a tight block of numbers in a grid for the body.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------