Sort by Priority - High, Medium and Low

Hi Team

I have a Priority Column with dropdown High, Medium and Low.

Since these cannot be sorted based on actual priority on Smartsheet Report and hence on Dashboard view, I have added a IF helper column that matches High to 1, Medium to 2 and Low to 3.

Issue being, when I sort the SS Report by this helper column, project get aligned correctly in order.

But as soon as I 'Group' them using Priority, the helper column sort doesn't work.

Please suggest,

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would have to group by the helper column. Instead of just using numbers, you can use text strings that start with the numbers.

High
Medium
Low

Gaurav Chauhan

Thanks.. Yes that what I actually did after posting my question. thank you.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.