edited 03/17/22 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!