Calculate sum for date range

  • 38
  • 1
  • Question
  • Updated 1 week ago
  • In Progress
I am tracking job backlog each week. Each week I have a list of backlog jobs. I need a way to compare how many jobs total are on the backlog list this week compared to last week. And I need it to be current so I can send the report to each area to track their progress i.e. are they gaining or losing every week. This was done in Excel previously but the person who tracked it is retiring so we're using Quickbase instead. Is there a formula or a way to calculate these numbers? Thank you.
Photo of Steve

Steve

  • 170 Points 100 badge 2x thumb

Posted 1 week ago

  • 38
  • 1
Photo of Debbie Taylor

Debbie Taylor

  • 664 Points 500 badge 2x thumb
HI, Steve -

There are a couple of different ways to create a report that tracks progress on your backlog.  The easiest way is to use a Quick Base automation.  So,
  1. Create a new table called 'Backlog History.'
  2. Create fields in that table like job, hiring manager, date opened, status.  Include Jobs table Record ID as a field.
  3. Go to the Jobs table (or whereever backlog jobs are listed in Quick Base.
  4. Click Setting-->Automations-->New Automation
  5. Choose "On a Schedule" for the trigger
  6. Set the frequency.
  7. Click "Add Action"
  8. Select "Add Record"
  9. Select the fields you want to record in your history (eg Hirng Manager) and the corresponding field in the Jobs table.
  10. Run the automation.
  11. Create a summary report in the backlog table.  (See below for sample settings.)
  12. Test, refine and repeat.
You can reach me at CloudBase Services if you have questions

Debbie