Search results

Thanks, Narayan ... I found a workaround - and my apologies to SirJB7. I ended up using VBA to create a macro ... this is what worked to ultimately create the result I needed. Hope it's helpful to anyone else who may be having the same kind of struggle: Sub TimelineMaster() Dim TimelineMatch...

Hi Ninjas ... any chance someone could give this another look now that there is more detail? My brain hurts from trying to figure this out! Many thanks!

My apologies Narayan ... here are the additional details. Column J is always a date - the desired deadline for the project task. I mocked up the row numbers in my earlier example, so I'll change those now to represent what's in my actual spreadsheet ... Rows 1-3 are actually header lines ...

Hi Ninjas, I have set up a series of 25 timeline template formulas, and used vlookup functions to design a way for users to answer a couple questions to determine which template they should use. The templates are designed to backfill the timeline based on the deadline date. (It's used to...

Thanks for your help! Narayan - I'm using the NOW() function to fill my cells. Cells that contain a date less than NOW() get one color, cells that contain a date between NOW() and NOW()+5 get another. And yes, I have multiple consecutive cells that will have #N/A in them. SirJB7 - I'll...

Quick clarification - the N/A isn't text ... it's an error - #NA - (I used formulas to calculate the dates in the timelines).

Hi Ninjas! I have a sheet of project timelines where each column is a step in a process, and each row is a project. Dates are entered in each row when the step applies to that project, and n/a is entered when the step does not apply. My goal is to use conditional formatting to fill the cell...

Hi Ninjas! I have a series of project plans, in table format, with an activity in Column A and a Start Date in Column B ... and a Project Name in Column A a few rows above the table. I need a way to generate a list that tells me what projects have tasks due this week. I'm already using the...

I'm developing a project dashboard with the following data: Column B - ID C - Project Name G - Budget H - Spent M - Budget Source I have dozens of projects - some with budgets, and others without. I need to create a chart that shows the Budget vs. Spent data for only those projects that...

I'm loving the Project Portfolio Dashboard! Thanks so much for the great work! The template is designed to display up to 50 projects, but I'm anticipating more than that for some of the dashboards I will need to develop - how do I get more than 50 projects to display? Thanks in advance for...

I've got a portfolio of roughly 30 projects, and need to create a way to display the current activity in a combined list on the dashboard ... I've played around with all kinds of different functions, but can't seem to find the right one. The data is set up as in the dashboard template...

Hi I'm Ann and am using your Project Profile Dashboard to manage a ton of Marketing Communications projects. Thanks so much for all the tips, this has been a huge resource! Looking forward to working with you!