Need to pull report based on first "No" or BLANK
So I have a PARENT/CHILD relationship in this sheet. I need to pull a report for CHILDREN rows that the next task to be done. What would the formula look like that identifies the row highlighted so I can include it in a report? I'm thinking something along the lines of this logic (this isn't the actual formula):
=IF(INDEX(CHILDREN([Helper for Ready to Hand-off]), return the first occurrence of "No", OR return the first BLANK (I could leave the "No" out of that columns formula.
Appreciate any ideas!
Help Article Resources
Check out the Formula Handbook template!