How to pull the most recent status symbol from another sheet?

Brittaney Pizzato

Hello,

I am trying to pull the most recent status symbol based off of the most recent date to another sheet.

Basically, I am trying to get the yellow status symbol from the 20th to pull into another sheet and once someone creates a new update with the most recent date/symbol, that symbol should be automatically updated from the 20th to the most recent date/symbol.

I tried to use this formula, but it only pulls the green symbol and I need it to collect any color that is most recently updated.

=INDEX({Project Health}, MATCH(MAX(COLLECT({Date}, {Project Health}, @cell <> "Green")), 0))

Hoping you can help! Thank you.

Scott Peters

Hi @Brittaney Pizzato - You would match the max date against the date column, and you don't need Collect in this scenario, so it could read as =INDEX({Project Health}, MATCH(MAX({Date}), {Date}, 0))

Scott Peters

Hi @Brittaney Pizzato - You would match the max date against the date column, and you don't need Collect in this scenario, so it could read as =INDEX({Project Health}, MATCH(MAX({Date}), {Date}, 0))

Brittaney Pizzato

Thank you, Scott! This worked!