What is the alphabetical order of non alphabet characters in Smartsheet
I am wondering what characters (symbols etc.) come after 'Z' when sorting alphabetically in Smartsheet in the same way that an underscore '_' is ahead of 'A'.
I am trying to change the order that my grouped items appear in a report and I have a grouping that starts with 'A' and I want it to go to the end.
Best Answer
-
When you are setting up the grouping you should have the option to group in ascending or descending order.
Answers
-
I believe that letters are basically the end of the line for sorting.
special characters (not sure exactly which ones come first)
numbers
letters
You may need to sort in the opposite order.
-
That's unfortunate. I don't think it's possible to make a grouping in a report appear in reverse alphabetical order, is it?
-
When you are setting up the grouping you should have the option to group in ascending or descending order.
-
Hey @Eric Strashin,
I've been wondering about symbol sorting too! 🤔 So in column I typed out all special characters along with representative normal characters, and I then sorted the rows. (Note: you cannot use = nor ' as they have special functions in a cell. Space disappears if you try to put it at the start).
Hope this helps! 😄
Ascending Order:
0
9
!
"
#
$
%
&
(
)
*
+
,
-
.
/
:
;
<
>
?
@
[
\
]
^
_
`
a
A
z
Z
{
|
}
~
Blank
-
Adding: here's a horizontal representation of the same info 😜
0 9 ! " # $ % & ( ) * + , - . / : ; < > ? @ [ \ ] ^ _ ` a A z Z { | } ~ Blank
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives