+ Reply to Thread
Results 1 to 2 of 2

Project Timeline Tracker

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    18

    Exclamation Project Timeline Tracker

    Hi,

    I'm new to this, and appreciate any input - even if you can only tell me that what I'm trying to do is impossible!

    I have a Project Timeline Overview that shows what projects are coming down the pipeline. I've got a start & end date, with what I would call a Gantt chart showing from April 1-Dec 31 2013, with bars (shaded cells) across wherever the project lies based on the dates.

    I have another column that shows the scope of work, small/medium/large. I need a formula to put into the SHADED ONLY cells to show the following:

    Small = 1
    Medium = 1
    Large = 2

    So basically, I need to input a formula that pulls these numbers based on what is in the Scope of Work column.

    ANY IDEAS? I used an "and" w/ nested "IF" formula to put a "1" in all of the cells that have shading, but I cannot figure out how to connect it to the Scope of Work.

    Thanks!!
    Attached Files Attached Files
    Last edited by AnnaG87; 05-01-2013 at 11:55 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Project Timeline Tracker - RUSH!!

    Hi and welcome to the forum

    Try this in O2, copied down and across...

    =IF(AND($L2<=P$1,$N2>=O$1),IF(OR($I2="small",$I2="medium"),1,2),"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1