I wanted to use the Google sheets to sort the column in descending order when check box is enabled
I have tried assigning the value to the sheets and import the application it should be interfering into the data but couldn't resolve the issue
if(A2,FILTER(A3:A,A3:A>0),0) ,Assuming A2 is the checkbox presence
Also tried SORT function but both are creating errors like Array result was not expanded because it would overwrite data in A4.
Aucun commentaire:
Enregistrer un commentaire