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.
