i have performed calculation of some status staying in grid and that is changing on everyday basis i am not storing that value in any database .
and that status calculation is happening and dependent on many field . how can i apply sorting when dependency of that data is not on any particular field.
Discussion posts and replies are publicly visible
Sort works only on fields not on logical value. My suggestion is create a custom field with this logic within your record and then you can use that field directly here and apply sort.
docs.appian.com/.../custom-record-fields.html
venky is there any substitute for now() function in appian becz custom record field does not support now() function . This function i have used for calculation.