Help to Sort by number and words

currently we have a built in prioritization score based on the data entered on the intake form

This will populate either a score of 1-5 OR the word "Tech"

When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first

I am able to sort but not able to get the words to come last in that descending order - can anyone help?

Find more posts tagged with

Formulas

Dashboards

Conditional Formatting

Card View

Enhancement Request

Accepted answers

All comments

Nick Korna

@PaigeKucz,

I can't see a way to do it directly with the single column, but you can certainly do it with a Helper column. In your helper column use the following formula:

=IF([Tech/Score]@row = "Tech", 0, 1)

You can then sort with the Helper column as the 1st sort criteria and Score as the 2nd (both descending) to get your scores into the desired order, with "Tech" last.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.