Dynamically populate column values from one sheet to another with conditions

Hi all,

I am trying to populate a column of project codes from the Master Project List to a metric sheet. All the project codes are unique, but from what I have read, to keep it updating dynamically I have to have a Unique number (primary column). I was able to get this to work with this formula:

=IFERROR(INDEX(DISTINCT({Master Project List - Project Code}), [Primary Column]@row), "")

However, there are almost 800 project codes. I'm already having a problem with too many cross-Sheet references on the Metrics sheet. So, I only want the ones that are marked as Active. I tried the formula below, but can't get it to work.

=IF({Master Project List - Active} "Active", INDEX(DISTINCT({Master Project List - Project Code}), [Primary Column]@row), "")