Skip to content
  • Try for free

    • 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.

      · Share on FacebookShare on Twitter

    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.

      · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video