Best Of
Unique() or Distinct() function for finding unique values
Hi,
It would be very helpful if Smartsheet redesigns the DISTINCT function so it can be used not just as an argument, but also at the top level to pull all unique values from a column.
For example, if a column titled Customers has many duplicate names, we should be able to use a formula like:
=DISTINCT([Customers]:[Customers])
When converted to a column formula, it would dynamically return a list of unique customers.
Without this, we have to create multiple complex formulas to achieve the same result, which is very cumbersome.
A major benefit of this capability would be the ability to use (for example) the RANKEQ() function to quickly find the order in which our customers spent the most on our products or services.
zealvert
Badge Notification in Smartsheet University
Ii would be a great addition to receive a notification once a badge path has been started to bring awareness to the goal and encourage the customer to complete it.
A notification of how close they are to the goal would be a great feature as well, such as when Smartsheet University will send a reminder email that a course was started and needs to be completed.
Shaq McWilliams
Mode Function
A formula for the Mode of a column would be helpful. I have gotten help from the community members on alternatives with helper columns and have found methods online but having a set function would make the process more efficient.
Shaq McWilliams
Re: Alternate Email Address Report
Definitely need this for security purposes. Looking for options to find one now.
KarinR
Re: Need to remove decimals from my Dashboard pie Charts. Please help.
Agree, I was worried they are going to make it permanent, it changes my charts so drastically, not happy about that π‘
Kelly Kenney
Re: Engage Conference 2025
Thanks everyone for sharing such great advice with @AmberEspindola!
@Paul Newcome great call! I think this is the post you are talking about: Connect and hear from past ENGAGE attendees
Rebeca S.
Blink Effect" inside joke, the "AJ Effect/Boomer Effect
Feature Request: Enhanced Ctrl+F Highlight for Smartsheet
Dear Smartsheet Team,
We want to suggest an enhancement to the Ctrl+F (Find) functionality within Smartsheet. Currently, when using Ctrl+F, it can sometimes be difficult to immediately spot the highlighted search result, especially in larger sheets.
We propose that when a search result is found, the outline of the cell containing the text changes to a sharp, contrasting color and blinks. This would significantly improve visibility and user experience by making the found instance much more noticeable.
Internally, we're calling this the "Blink Effect" or, as a bit of an inside joke, the "AJ Effect"βyour phone rep actually encouraged me to suggest the latter as a potential name, saying your R&D department has a great sense of humor and might even give me credit for the feature!
Thank you for considering this request. It would be a valuable addition for your users.
Sincerely,
A. Johnson β¦.A.J
ajohnson2
Re: How do I stop my report from generating numbers to the 4th decimal?
This technique does not work.
Lisa VanDine
Re: Has URL-Encoding for automatic Date Entry in SS Forms changed?
Thank you @jmyzk_cloudsmart_jpβ¦the URL is created in our Filemaker Database so if this change ends up being permanent I'll have to reformat the date at that end. Per the post Andree forwarded, it looks like others are having similar issues so hopefully we'll see a fix soon.
FrogHolder_01
Re: New streamlined creation experience
Hi Community,
Thank you for your feedback on the recent sheets folder changes. I understand these changes to your workflows have been frustrating, and I want to provide clarity on our reasoning and next steps.
Why we made this change: Based on customer research, we identified several pain points with the sheets folder:
- It had become an overwhelming, disorganized repository mixing useful and outdated assets
- New users found it confusing (why does it exist separately from workspaces?)
- The "Sheets" name was misleading since it contained multiple asset types
- Large sheets folders caused slow loading times and platform stability issues
What's next: We're taking your feedback seriously and adjusting our approach. In the coming weeks, we'll share our updated strategy for the sheets folder and specific timeline for improvements. We recognize this change disrupted established workflows, and we're committed to providing better solutions to serve our customers.
Thank you for your patience as we work through this together.
Jason