Get the value with the latest Date
I need help in getting the value from the item column of Test Sheet1 which has the latest date and put it in the test sheet 2.
I am trying to use, join(collect(Item sheet1 , Date, max(Date(@cell)) but not working.
Can you help me with the correct formula? And second question, what if I have 2 reference sheet (Sample Test sheet 3). How to adjust the formula?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!