flag if

Samuel Dowdy Jr.

I want this to say flag if the task end date is greater than the hard stop date and Task Status in still in progress or not started

Paul Newcome

Try something like this...

=IF(AND(OR([Task Status]@row = "In Progress", [Task Status]@row = "Not Started"), [Task End Date]@row > [Hard Stop Date]@row), 1)