Best Of
Translate multiple-select items to individuals rows
Please consider updating Smartsheet so that when someone selects multiple options in a multiple-select drop down on a form, each selection will populate into a new row in the primary grid with all of the original single select information also included. For example, if someone is signing up to attend both lecture 1 and lecture 2, two rows would populate on the grid, one with all of the individual's information and the selection of lecture 1 and a second with all of the individual's information and the selection of lecture 2. This would allow for more easily reporting and organization information based on preferred selections. Thanks!

Remove GO to sheet option
There should be a way to remove the "Go to the Sheet" button / link at the bottom of an update request. Often users do not have access and then they keep requesting access by using this link.

Re: extract part of a cell's text
I suggest using the RIGHT function and automating how many characters to pull so that you don't have to worry about hardcoding whether it is 4, 2, or 23.
=RIGHT(Dimention@row, LEN(Dimension@row) - FIND("*", Dimension@row))
.
The LEN function gives you the total count of characters. The FIND function looking for the asterisk gives you how many characters from the left the asterisk is found.
.
Ø120*12
is 7 characters long. Subtract the position of the asterisk (5), and you tell the RIGHT function to pull 2 digits.
Ø18*1000
is 8 characters long. Subtract the position of the asterisk (4), and you tell the RIGHT function to pull 4 digits.
.
This will maximize your automation by basing it off of the data itself instead of manual calculations.
.
If you were planning on using this data that you are pulling as actual numbers in the future as opposed to just displaying them as a text string, you would need to wrap the entire formula in a VALUE function.
=VALUE(RIGHT(Dimention@row, LEN(Dimension@row) - FIND("*", Dimension@row)))

Re: April Question of the Month - Join the conversation and receive a badge
Great suggestions so far!
I'm a newbie. I'd love to get context specific help. For example, "Hey Smartsheet! How can I show which tasks are behind schedule on this sheet?"

Re: Chart Labels: drag labels overlap & stacked column labels
Applying value labels to data in a stacked column places the numerals above each data bar. For a stacked chart, I expect the value label numeral to be placed within the data bar. It is very confusing to have the value labels this way and could lead to misinterpretations.
In the attachments are the current Smartsheet outcome with sketched arrows showing where the numerals should be placed.
The other attachment shows the Excel version of what I would like for the placement of the value label numerals. It seems like it should be default to have the value label within the data bar when stacked.

Generate Docs - How to fix Font Size Issues - a guide
I'm was using Generate Form to create a PDF I needed. While I was getting the content I needed, the font size in the form was wonky and inconsistent. The first 3 fields were in LARGE FONT size while the rest were a standardized. I don't know why or how the this happened. I was able to find a solution after an hour + of sleuthing. In hopes of saving others the hassle, I've attached a quick how to guide.

Re: @ people within WorkApps commenting
Please Add Full @mention Functionality to WorkApps. I Have to Type The Entire Email Address to Use @mention Functionality.
Re: @ people within WorkApps commenting
Would like the ability to tag someone via @mention in a row comment via a page accessed thru a WorkApps.

Re: Rich Text formatting in cells
Adding onto Heather's excellent list above...
• tiered bullet points within a cell (different bullet style for different levels of text indent). Use case: We use bullets all the time in "executive summary"/comments cells that roll up to a leadership dashboard. They break up the text and make it easier to read at a glance. Tiered bullets would be especially good for documentation housed in a Smartsheet, something I am working towards to keep our project toolkit centralized.
• numbering within a cell (creating numbered lists of text). Use case: Logging several steps that must be completed to resolve a risk on a risk log, and other numerous similar cases.

Re: Auto Sort Smartsheet
It's almost 2 years since this issue was raised. It's a very useful feature and I don't understand why it takes so long to be implemented.
Please advise if smartsheet has any timeline to implement this.
