Return Next Pending Task in Summary Sheet
Apologies if this has been asked before, but I'm struggling to find what I need and am not the best at formulas. I want to include a field in a sheet summary that shows the next pending task, but can’t seem to get it to work. Here’s a bit of an explanation…
Let’s say I have a sheet with two columns…Status and Task.
Basically, I want a formula that returns the Task if the Status equals “Not Started” or “In Progress”. INDEX/MATCH works perfect if I’m looking for one criteria; such as:
=INDEX([Task]:[Task], MATCH("In Progress", Status:Status, 0))
But, I’m struggling to put something together that returns the Task if I’m looking for one of two different criteria. I’ve played around with several different functions and can’t seem to get it right. More than likely something simple I’m overlooking…
Would you guys be able to point me in the right direction on this?