Formula to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already passed, so we have more of a heads up in our reports, but I don't know if there's a way to do that at all. I'm assuming there needs to be a nested =IF(AND(..., but I don't know how to format the rest, what the column numbers would be, etc. I also don't know how to put it so that it applies to the entire column (or every task in the column). The only time I wrote a formula that wasn't unparseable (though it didn't work properly), it only applied to the first cell in the column.
Help Article Resources
Check out the Formula Handbook template!