I have the following formula which is working perfectly for all the filters and the search bar. Currently I am sorting the gallary view by “created on”. Can someone guide me how can I add Created by , Assigned to, and post dated to the sort functionality as well. Check the screenshot
SortByColumns(
Search(
If(
// All blank
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value = Blank(),
'Oss_Intake Requests',
// All not blank
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Assigned To'.'Full Name' = filterassign.Selected.'Full Name' And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category' And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
//-------------------------------------- 3 Blank-----------------------------------------------------------
// priority-no,assign-blank,cat-blank, status-blank
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value
),
// priority-blank,assign-blank,cat-no,status-blank
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
'Request Category'.'Request Category' = filtercategory.Selected.'Request Category'
),
// priority-blank,assign-no,cat-blank, status-blank
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
'Assigned To'.'Full Name' = filterassign.Selected.'Full Name'
),
// priority-blank,assign-blank,cat-blank, status-no
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// ------------------------------------ 2 Blank----------------------------------------------------------------
// priority-blank,assign-blank,cat-no, stat-no
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
'Request Category'.'Request Category' = filtercategory.Selected.'Request Category' And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// priority-no,assign-no,cat-blank,stat-blank
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And'Assigned To'.'Full Name' = filterassign.Selected.'Full Name'
),
// priority-blank,assign-no,cat-no,stat-blank
filterpriority.Selected.Value = Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
'Assigned To'.'Full Name' = filterassign.Selected.'Full Name' And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category'
),
// priority-no,assign-blank,cat-blank,stat-no
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// priority-no,assign-blank,cat-no,stat-blank
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category'
),
//-------------------------------------------- Any 1 blank ----------------------------
// priority-blank,assign-no,cat-no,stat-no
filterpriority.Selected.Value = Blank() Or filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
'Assigned To'.'Full Name' = filterassign.Selected.'Full Name' And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category' And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// priority-no,assign-blank,cat-no, stat-no
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' = Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category' And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// priority-no,assign-no,cat-blank, stat-no
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' = Blank() And filterstatus.Selected.Value <> Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Assigned To'.'Full Name' = filterassign.Selected.'Full Name' And 'Status (crecb_oss_status)' = filterstatus.Selected.Value
),
// priority-no,assign-no,cat-no, stat-blank
filterpriority.Selected.Value <> Blank() And filterassign.Selected.'Full Name' <> Blank() And filtercategory.Selected.'Request Category' <> Blank() And filterstatus.Selected.Value = Blank(),
Filter(
'Oss_Intake Requests',
Priority = filterpriority.Selected.Value And 'Assigned To'.'Full Name' = filterassign.Selected.'Full Name' And 'Request Category'.'Request Category' = filtercategory.Selected.'Request Category'
)
),
SearchbyMember.Text,
"crecb_oss_membername","crecb_account"
),
"createdon", Descending
)