Forum Discussion

MarkCapretta's avatar
MarkCapretta
Qrew Trainee
8 years ago

Install Status This Week

Hey folks,

I'm tracking installation status (Not Started, Started, Completed) by week of & I have actual start dates. I'd like to create a summary report that shows the status of the installs throughout the week.

For example, Site# A starts on Wednesday. I want it to show on Monday that it is "Not Started" and once the site is started (by the "Actual Start Date" being filled in), it will flip to "Started". And once the site is completed (By "Installation Completion Date" being filled in), it will flip to "Completed".

What I'm looking for is how to appropriately set the filters on the summary report that will prevent me from having to update it every Monday morning.

Thank you!!!
App builders
Ask about Quickbase functionality
Formulas and functions
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Do you have a "Scheduled Install Date"?  You will need to have some identifier that make is fall into the 'current week'.  Because your other dates are blank at the beginning of the week.

    Also, you will want to make a formula-text field that evaluates the conditions and returns one of the three options; Not Started, Started, Completed.
    • MarkCapretta's avatar
      MarkCapretta
      Qrew Trainee
      8 years ago
      I have an "Estimated Install Start Date", and my formula is already built and working properly.
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      8 years ago
      Try using the filter;
      [Scheduled Install Date] is during the current week.

      Or if you want to show several weeks and their status, expand the filter a few weeks, but then group the summary report.

      Taking it to the next level would be to use a 'stacked bar chart'.
      The x -axis would be your 'scheduled install date' grouped by week.
      y-axis is '# of jobs' (option at the bottom of the list).
      series would be 'status'.

      Its a strong visual to easily see progress and updates.