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!!
Bookmarks