Collecting earliest date based on certain criteria
I'm trying to pull the earliest date that a status symbol was Red or Yellow unless that date is followed by a Green status symbol and then a Red or Yellow status symbol. In that scenario, I would want the Red/Yellow date after the Green date to be shown in the Roll-up Sheet.
In the example below, the Roll-Up Sheet should be showing 11/24 instead of 11/2 but I cannot find out what formula (or if its even possible).
Help Article Resources
Check out the Formula Handbook template!