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?
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 479 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives