lundi 1 avril 2019

Check box use in google sheets

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