Hello all,
I'm hoping you can help me with a problem I've come across.
In the attached document is a sample of a project tracker I've put together, that is meant to track whether Projects are on Time to meet their "Go Live" dates. This is done by comparing the "Go Live" dates reported each month, against those in the project baseline - see the "04.2 - Go-Live Baseline" tab.
Initially I used the following formula:
=IFERROR(IF([@[Go Live Reported]]=INDEX(Table6[Original Forecast],MATCH([Project],Table6[Project],0)),"Yes",""),"")
However, I soon realised that there were instances where the Go Live date was being brought forward (cells highlighted orange), and that the formula above does not account for this, and ignores any differences to the baseline.
I then made the following amendment:
=IFERROR(IF([@[Go Live Reported]]<=INDEX(Table6[Original Forecast],MATCH([Project],Table6[Project],0)),"Yes",""),"")
While this did work in part, it had the unexpected outcome of including instances where no dates were reported - see cells G77:G81, highlighted yellow. I thought of using a date range, such as January 2020 (i.e. no earlier than) onward, but I can't figure out how to implement this.
As such my request is the following. Is there a formula I can use, or a way to alter the formula above, to deliver what I'm looking for, while ignoring any blank cells?
I hope this is all clear, but happy to try and elaborate further if needed.
Many thanks in advance for your help, and I look forward to hearing from you!
Kind regards,
G
Bookmarks