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

Options

Best Answer

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓
    Options

    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.

Answers

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓
    Options

    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.