Search results

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...

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...