Best Of
Increase the Latest Comment Column Character Limit
The 'Latest Comment' column is a great feature to add the most current information into sheets and reports. It's helpful to be able to provide our executive team printed reports containing all of the information they need. And they don't have to worry about accessing Smartsheet directly. Unfortunately, we recently found there's a 350-character limit on the 'Latest Comment' column. So, we're not able to provide all of the information in a report if a comment exceeds 350 characters. If the 'Latest Comment' column could be adjusted to allow the default character limit of a text/number field of 4,000 characters, then we'd be more likely to be able to fit the whole comment.

Re: Dynamic dropdowns - Waterfall request
This would be incredibly helpful for us. I would be happy to just be able to reference a column in another sheet - just like you would do with a regular sheet reference to build out my applicable dropdown values. To have the ability to sort or not sort the list within the dropdown properties would be a 'nice to have'.

Sheets, Reports, Dashboards and Workspaces now tied to Smartsheet Plans instead of Individual users!
Hi Community,
Today, we’re excited to announce that sheets, reports, dashboards, and workspaces are no longer tied to individual users but instead they are tied to Plans. This means that as users change roles within organizations, leave organizations, or have their licenses removed, business workflows and processes built with Smartsheet will continue to function. SysAdmins will no longer need to chase down deactivated assets to keep their businesses humming, no matter where individuals go.
This enhancement is being rolled out to all users on all plan types. There is no action to take, this enhancement has been made on the backend of all sheets, reports, dashboards, and workspaces.
You can learn more about this enhancement in this help article: Manage licenses when transferring items
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Melissa Hopelain
Sr, Manager, Product Marketing
Re: Folder-level permissions
Yes!
I was looking for this thread for so long.
We need folder-level permissions instead of only workspace-level and sheet-level permissions.
My department has several teams who own a folder each. So, giving access to a set number of users in a folder is easier than giving them all sheet-level access one by one.
Regards
Sowmya

Re: Our first ENGAGE challenge is here - Smartsheet Travel Diaries 🗺️ + Bonus Giveaway
I enjoy traveling to work (remote😀) to be with the best co-worker! If I travel to get lunch or take a break outside this guy is with me 24/7 supporting all of my Smartsheet ideas.

Include date/timestamp next to last comment
Include date and/or timestamp next to the last comment displayed in the cell to quickly reference when the last comment was created. Enable this as an option.
Re: How to extract just the month name from a date
Nested IFs are useful when you need the full month name, but for three digit month names you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

Re: FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
If you only need three digit month names the formula is much simpler:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

Re: Month Name written as Text for Today's Date
Nested IFs are useful when you need the full month (eg. January) because they are all different lengths.
But for three digit abbreviations you can use a much simpler formula:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

Re: Formula - Return month as text from a date cell.
If you only need three digit month names the formula is much simpler:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)
