Best Of
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
Re: Merging CountIFS and Contains
@pbartlett117 This formula would work, =COUNTIFS([Study Number]:[Study Number], CONTAINS("UE", @cell ), Species:Species, "Rat")
HOWEVER, that assumes that the cells containing "rat" don't contain any hidden characters or spaces. Which, being this is a free text field it's possible. also possible if you copy and pasted the date in from somewhere else.
Soโฆ to troubleshoot you could clear out a rat cell (sounds like a lab procedure ha ha) and retype it to see if that's the case. OR you could take the less precise route and use contains to search for ratโฆ
=COUNTIFS([Study Number]:[Study Number], CONTAINS("UE", @cell ), Species:Species, contains("Rat",@cell))
Darren Mullen
Re: Merging CountIFS and Contains
You are also referencing entire columns with your test data in the middle of the sheet. Try applying a filter that matches the same ranges and criteria as your formula to see if maybe there is a third row somewhere that fits.
Paul Newcome
Re: Weekly Reports - Best Practices or Tips?
Thanks for the extra options, @StevenBlackburn - sounds like I've got the best solution I can ask for within Smartsheet's capabilities right now.
We'll talk with the team to see how they want to share this. We'll have a couple people who will need to prepare and submit these reports (including new hires), so we want to make sure the steps are easy enough for everyone to pick it up and run with it.
Hopefully I can convince them to share it as an image within Outlook and we can go from there. :)
S.Stone