Skip to content

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

Amelia Gorman

Amelia Gorman ✭✭

10/14/21 in Smartsheet Basics

Grow Reach Report_grouping by priority.png

Tags:

Reports

0 ·

Best Answer

Jason Duryea ✭✭✭✭✭✭

10/14/21 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.

0 · Share on Facebook Share on Twitter

Answers

Jason Duryea ✭✭✭✭✭✭

10/14/21 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.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

External Reporting
Hello - I am trying to create an external report where I only want certain rows (such as with checkbox) but I do not want to put a filter on the report because then the external resource could then ex…
Answered ✓
reporting
Smartsheet Basics
27
8:31 pm
7
Does Smartsheet have the capability of tracking external users that complete a Form?
I created a external ticketing system in smartsheet and set up automation for a message and survey to be sent to the person who submitted the ticket. Ticket submissions will come from people outside o…
Answered ✓
Forms
external users
Smartsheet Basics
32
Apr 13, 2025
4
Are New Folders No Longer Allowed In Sheets Directory
Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create …
Answered ✓
Sheets
organization
Smartsheet Basics
209
1:59 pm
7

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