Formula to count status and due date in the past
Hi, hoping that someone can help...
I'm trying to add a field into my Sheet Summary, to highlight tasks that are overdue, but need to excluded tasks that are 'Complete'. This is what I've tried, however the error message is #Unparseable.
=COUNTIF(Launch:Launch), <TODAY(), + COUNTIF(Status:Status, "In Progress"), (Status:Status, "Under Analysis")
Any ideas? Thank you