Find

MvH

Hello everyone,

I'm afraid this is a very basic question: How do I find the start/end date (or generally any other value from a row) of the main task in my sheet? By "main task" I mean the tasks that governs all others tasks, where ANCESTORS would equal zero, but that's not neccessarily in row 1.

So far I have tried to use INDEX and COLLECT where ANCESTOR=0 will determine which tasks is the main taks. I get various error messages... Please help, thanks!

Paul Newcome

You will need a column with a basic formula to output the ancestor count onto each row:

=COUNT(ANCESTORS())

Then you can use something like this...

=INDEX([Start Date]:[Start Date], MATCH(0, Ancestors:Ancestors, 0))

MvH

Hi Paul,

thanks for your quick response! Upon using =INDEX(Start:Start, MATCH(0, Ancestors:Ancestors,0)) I am now getting an "invalid column value" error back. Any ideas?

Paul Newcome

The formula above would need to go into a date type column as it is pulling a date value.