Multiple criteria with INDEX and MATCH / COLLECT with MAX Functions
I have the below columns in my Smartsheet and I would like to retrieve Finance column value if Quarter=2, Year=2021, Req Type=L and Max(Row ID).
I tried with below query but failed and I am not able to see how MATCH / COLLECT Function can be used. Any help would be greatly appreciated.
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!