Hi! Trying to reorder the grouping of priority on this report to: Highest, High, Medium.

Amelia Gorman

Jason Duryea

Create a helper column in the source sheet with a column formula to set a numeric value for Priority.

=IF(Priority@row=“Highest”, 1, IF(Priority@row=“High”,2,””))

Then sort the report with the helper column and hide the column on the report.

Jason Duryea

Create a helper column in the source sheet with a column formula to set a numeric value for Priority.

=IF(Priority@row=“Highest”, 1, IF(Priority@row=“High”,2,””))

Then sort the report with the helper column and hide the column on the report.