Cell formula that will highlight a task expired if any of its sub tasks are expired
I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired.
For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired.
Is there a formula available for this?
Help Article Resources
Check out the Formula Handbook template!