Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

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

Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    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

  • ✭✭✭✭✭✭
    Answer ✓

    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.

Trending in Smartsheet Basics