Hello everyone, need some assistance to change this formula sortby so, removing the current sortby and add one where it will sort the results automatically by date from older to youngest (short date, for example 10/10/2020)
Let me know if you need an example sheet or any more information,
Thank you
Excel Formula:
=LET(a,IFNA(VSTACK(FILTER(OneSummary!B3:E10000,OneSummary!B3:B10000>0),CHOOSECOLS(FILTER(Summary!BR8:BX5000,Summary!BR8:BR5000>0),1,2,3,4,5,7)),""),SORTBY(a,RIGHT(INDEX(a,,1),4)))
Let me know if you need an example sheet or any more information,
Thank you