Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace.
I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them.
I am sharing the following with the hope that:
1. Someone finds it useful.
2. Others have input on how to further this conversation.
Short Version:
Unicode Text Symbols are awesome. You can use them:
1. In Workspace Names for sorting.
2. To increase your symbol options.
3. To use symbols in the primary column.
4. To have multiple symbol types in a single column.
Does anyone have any input here?
你一直使用它们吗?
More Background:
These sheets and a report that articulate everything below.
文字符号-3 - Formatting & Formulas
I've got a lot of workspaces and I often use symbols to sort them. Starting a workspace name with "." or "!" will move it to the top of your list of workspaces.
I started playing around with some new text symbols and found that Smartsheet does not recognize some.
This ultimately led me to a few questions about Unicode Text Symbols in Smartsheet:
1. How many Unicode Text Symbols ARE recognized in Smartsheet?There are a bunch, but colors depend on your browser, browser version & the symbol itself.
2. If I use them in Workspace Names how will they sort?Varies - Searching for a workspace in reports doesn’t like them. You have to find the workspace by scrolling down the list.
3. Can I use them in Formulas?YES!
4. Can I use them in Conditional Formatting?YES!
5. Can I use them in Report Filters?YES!
6. Can I use them in API Calls?YES!
Check out the sheet links above to learn more.
♿ ♻ ⚓ ☏ ☎ Ω ๛ ᖰ ❤ ☠ ☢ ☣ ⚿ ⚽ ⚖ ☐ ☑ ✅ ✓ ⍻ ✔ ╳ ✗ ✘ ❌ ✖ ⭙ ❎ ⛝ ⛞ ☒ ❔ ❕ ❓ ❗ ✄ ✉ ➰ ✈ ▲ ▼ ► ◄ ✴ ✵ ✶ ✷ ✸ ✹ ✺ ✻ ✼ ❊ ✽ ⍟ ✪ ✫ ✬ ✭ ✮ ✯ ✰ ✱ ✲ ✳ ✾ ✿ ❀ ❁ ❂ ❃ ❄ ❅ ❆ ❇ ⌘ ⌗ ⍟ ✪ ✫ ✬ ✭ ✮ ✯ ✰ ✱ ⬆ ⬇ ⬈ ⬉ ⬊ ⬋ ⬌ ⬍ ⬎ ⬏ ⍅ ⍆ ⍇ ⍈ ⍏ ⍐ ⍖ ⍗ ↨ ↩ ↪ ➚ ➛ ➜ ➝ ➞ ➟ ➠ ➡ ➢ ➣ ➮ ➯ ➱ ➲ ➳ ➴ ➵ ➶ ➷ ➸ ⟵ ⟶ ⟷ ⟸ ⟹ ⟺ ⟻ ⟼ ⟽ ⤈ ⤉ ⤊ ⤋ ⤌ ⤍ ⤎ ⤏ ⤐ ⤑ ⤠ ⤡ ⤢ ⤣ ⤤ ⤥ ⤦ ⤧ ⤨ ⤩ ⤶ ⤷ ⤸ ⤹ ⤺ ⤻ ⤼ ⤽ ⤾ ⤿ ⥊ ⥋ ⥌ ⥍ ⥎ ⥏ ⥐ ⥑ ⥒ ⥓ ⥞ ⥟ ⥠ ⥡ ⥢ ⥣ ⥤ ⥥ ⥦ ⥧
- Sales
- Workspaces
- Media & Entertainment
- Human Resources
- Manufacturing
- Search
- Templates
- Non-profit
- Construction
- Sheets
- Hospitality
- API and Developers
- Healthcare
- 金融
- Education
- Formulas
- Account and User Management
- Government
- Reports
- Real Estate
- Services
- Legal
- Integrations
- Marketing
- 支持
- Enhancement Request
- Solution Center
- Dashboards
- IT & Operations
- Product Development
- Conditional Formatting
- Project Management
Comments
-
Great post! Thank you for putting this together and providing example sheets!
-
Travis EmployeeGreat post!
Would you be willing to share these sheets with me as a viewer so I can make a copy?
Thanks!
-
KrisWalsh ✭✭✭✭✭
Done! (:
-
Travis Employee
Thanks!
-
J. Craig Williams ✭✭✭✭✭✭Kris,
NICELY DONE.
Can you share to me as well?
I've got investigation of language support on my list and this seems related.
Craig
-
KrisWalsh ✭✭✭✭✭
JCW, I'd be happy to. I didn't see your email address on your profile, so please shoot it over. (:
-
J. Craig Williams ✭✭✭✭✭✭
-
KrisWalsh ✭✭✭✭✭
You have been added to the workspace, sir.
-
J. Craig Williams ✭✭✭✭✭✭
Thanks.
Impressive work.
Craig
Categories
@Ruvalcaba12<\/a> try his<\/p> Create a helper column called \"Helper\" and put this column formula<\/p> =IF(COUNT(CHILDREN([Planning Done]@row)) = 0, \"//www.santa-greenland.com/community/discussion/comment/\", IF(COUNT(CHILDREN([Planning Done]@row)) = COUNTIF(CHILDREN([Planning Done]@row), 1), 1, 0))<\/p> Then in your top level put this formula<\/p> =COUNTIFS(CHILDREN(Helper@row), 1) + \" of \" + COUNT(CHILDREN()) + \" Done\"<\/p>"},{"commentID":386074,"body":"
