Results 1 to 2 of 2

Thread: Last task clicked/last activity completed report

  1. #1
    Neophyte LaurieA's Avatar
    Join Date
    Nov 2018
    Excel Version

    Last task clicked/last activity completed report

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am managing a large scale project (700 active projects and growing) and am trying to give a cross functional team (approx 70 people) a snapshot of where each of their project sits currently in the timeline as well as performance progress by role (i.e. is one group performing their activities on time or are they consistently late). Each project has 16 activities. I have the following data:
    Project Name
    Project status
    Activity sequence
    Activity Name
    Activity status (not started, completed)
    Proposed Start Date
    Actual Activity End Date
    Proposed Activity End Date

    Is there a way to indicate on a pivot table (or some other nice view) what the last activity completed was in a project? My current pivot table uses the count of activity status (complete only) as the values in the pivot table, but it's messy to read.

    Oh ya, and I have Excel 2007 (not my choice, but I have to work with what I've got!)



  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Steamboat Springs
    Excel Version
    Suggest you upload a sample workbook showing a before and after scenario. Make sure you have enough representative data to demonstrate your issue and resolution. Mock up your solution manually so that we can replicate it properly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts