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


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!