Show the next task due

mccoy_FSI

All I am trying to do is show the next task in the Next Task column that has not be marked completed in the Status Column. I tried a bunch of different Index/Collect and Index match formulas but the best I can do is get it to return a blank. I don't understand why the below formula doesn't work.

=INDEX(COLLECT([Next Task]:[Next Task], Status:Status, @cell <> "Complete"), 1)

Leibel S

What is it showing?

Can you show a sample of your data?

DKazatsky2

Hi @mccoy_FSI,

Check all your data for accuracy. I recreated your scenario and cut and pasted your formula and it worked immediately. It doesn't appear to be an issue with the formula itself.

Hope this helps,

Dave

mccoy_FSI

@DKazatsky2 , I see what it is. The column I am looking at has blank fields. I need this formula to look at rows that are only Task Hierarchy level 2, but can't figure it out. I am using this formula but it returns a blank, but there is a task level 2 that is not complete.

=IF([Task Heirarchy]@row = 2, INDEX(COLLECT([Next Task]:[Next Task], Status:Status, @cell <> "Complete"), 1), "")

DKazatsky2

@mccoy_FSI

Please share a screenshot(s) to show what you have. Make sure to block out any sensitive data.