I am working on a spreadsheet where each person has their own project and
each project has 7 different phases. I would like the spreadsheet to look
down the percentage complete column and find the first <100% and report the
project title in that row as the current phase even if they are working on
multiple phases. They may be 100% with the 4th phase but if they havent
finished the 2nd phase then that is the current phase to report to the
executives.

So I guess I am looking to have it count the column and the first non =100%
it comes across, report it and it alone. When they finish that phase, it will
go onto the next one.

When all of the phases read 100%, I would like for it to refer to a
different cell that reads, "Complete"

I hope this makes sense to somebody.

I am thinking I need a If True if False formula but I am not sure how to
formulate it.