Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy guys , is there any way to sort one field by the value of other field?
I tried something like this , but it didn`t work:
if(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt'),
if(LEVEL1='Electronics',match(LEVEL2,'Laptop','Phone','SmartWatch')))
So the order should be
Clothes
-hat
-t-shirt
-shirt
Electronics
-laptop
-phone
-smartwath
Thank you.
"It didn't work" does not describe the problem. So I am guessing here
if(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt'),
if(LEVEL1='Electronics', match(LEVEL2,'Laptop','Phone','SmartWatch')+3))
Instead of that, You can try this too
If(Pick(LEVEL1='Clothes',match(LEVEL2,'Hat','T-shirt','Shirt')),
if(Pick(LEVEL1='Electronics',match(LEVEL2,'Laptop','Phone','SmartWatch'))))
"It didn`t work" means that it doesn`t order after my expression. What I expect to see is the order from above ,
but what I see is this :
Clothes
-t-shirt
-shirt
-hat
Electronics
-smartwath
-phone
-laptop
What expression you wrote?
Both of them and still doesn`t work. When I`m writing your expression it gives me error in expression at the last ')'.