Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a problem with sort express. How should look expression?
The sort order is ROZ, ZAW, W, PRZYPISANY
THANKS
MARTA
May be like this
Match(FieldName, 'ROZ', 'ZAW', 'W', 'PRZYPISANY')
This is Information is not enough and not clear.
Can u explain clearly with some some sample data along with output.
-Nagarjun
I have something like this
STATUS: ZAWIESZONY, PRZYPISANY_DO_GRUPY, ROZWIAZANY, W_TRAKCIE_PRAC
I wants to sort like this: ROZWIAZANY, ZAWIESZONY, W_TRAKCIE_PRAC, PRZYPISANY_DO_GRUPY
But I do not know how sort expression
This?
=Match(STATUS, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')
It is like Sunny T said.
Go to the object properties. Click the sort tab. Click on the field you want to sort by... add the expression
match(YOURFIELDNAME, 'ROZWIAZANY', 'ZAWIESZONY', 'W_TRAKCIE_PRAC', 'PRZYPISANY_DO_GRUPY')
choose either ascending or descending, depending on how you want it to sort.
Hi,
Go to Sort expression,put like this,
If(YOURFIELDNAME='ROZWIAZANY',1,
If(YOURFIELDNAME='ZAWIESZONY',2,
If(YOURFIELDNAME='W_TRAKCIE_PRAC',3,
If(YOURFIELDNAME='PRZYPISANY_DO_GRUPY',4))))
set as Ascending order.
All of these solutions not work
Would you be able to share a sample to look at what you are trying to do?